Thank you for your quick answer. Your advice works! Another question.

I have a long list of all the countries of the world with only one variable named COUNTRY_NAME , a 25 characters string.

Is it possible to use the LEGAL command with a REC file with only one variable?

Or do I have to add lable names or numbers for each country to use the

COMMENT LEGAL solution?

Franco L. Sanavro

Epidemiologist

Regional Health Centre

GGD Zuid-Holland Zuid

Dordrecht

The Netherlands

-----Oorspronkelijk bericht----- Van: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca]Namens epidata-list-request@lists.umanitoba.ca Verzonden: zaterdag 24 november 2007 19:03 Aan: epidata-list@lists.umanitoba.ca Onderwerp: EpiData-list Digest, Vol 49, Issue 13

Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca

To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca

You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca

When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."

EpiData-list mailing list ___________________________________

Today's Topics:

1. Re: How to use large amounts of of legal values in chk file (epidata-list@lists.umanitoba.ca) 2. Re: Using Comment legal in recfiles (epidata-list@lists.umanitoba.ca)

----------------------------------------------------------------------

Message: 1 Date: Fri, 23 Nov 2007 23:55:34 +0100 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] How to use large amounts of of legal values in chk file To: epidata-list@lists.umanitoba.ca Message-ID: 47475A66.5060104@tbrieder.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed

EpiData Entry most likely does not recognize *.inc. Assume that your POSTCODE.INC file has two fields: name postcode

where NAME is the place and POSTCODE its postal code. Make a text file, eg NAMECODE.TXT containing only these two fields, semi-colon delimited. Then make a QES file, e.g., NAMECODE.QES with just two fields:

name _________________ postcode ####

Then use the import function to import the NAMECODE.TXT file.

Now edit the NAMECODE.CHK file so that:

name key 1 end

postcode key 2 end

Go now to your MAINFILE.REC and edit the MAINFILE.CHK in the appropriate place to:

postalname COMMENT LEGAL namecode.rec SHOW TYPE COMMENT postalcode END

postalcode NOENTER END

(assuming you have these two fields). Now the data entry person gets the external file as a label block, with POSTALNAME as the field value that can be found quickly, and the POSTALCODE as the value label, written into the appropriate field.

Hans

epidata-list@lists.umanitoba.ca wrote:

We are building a data-entry system for the registration of medical contact for the youth in our organisation. Therefore we need several hundreds of schoolcodes and zipcodes (postcode).

I want to use an externel file POSTCODE.INC whith the data and used the following syntax:

LABELBLOCK LABEL_POSTCODE INCLUDE POSTCODE.INC END

POSTCODE LEGAL USE LABEL_POSTCODE MUSTENTER END

But I only get errors.

Someone has a solution?

Franco L. Sanavro