- EpiData-list - University of Manitoba Mailing Lists

Regarding automatically filling of fields
by epidata-list＠lists.umanitoba.ca 12 Jan '07

12 Jan '07

To Jamie, Jens Lauritsen, Hans and all of you that follow this thread and came with many helpful suggestions 'Thanks'. After trying different models, I managed to create a Syntax that allow me to enter data in one field and get automatically related data filled up in two other fields. I had to split the helping REC file into two files. The Key variable in the first file was the brand (say Aspirin) and the second variable was the Generic name (say ASA), and in the second file the Key variable was the generic name and the second variable the ATC code. If somebody may give a feed back, I will appreciate it. The two 'Helping files' look like this: Brand-Generic (MedGen.REC) MedNvn Aspirin MedGen acetylic salicylic acid MedNvn Beuron MedGen acetaminophen MedNvn Efferalgan MedGen acetaminophen MedNvn Panadol MedGen acetaminophen MedNvn Paralen MedGen acetaminophen MedNvn Tyelenol MedGen acetaminophen Generic-ATC (MedATC.REC) MedGen acetylic salicylic acid MedATC n02ba01 MedGen acetaminophen MedATC n02be01 MedGen acetaminophen MedATC n02be01 MedGen acetaminophen MedATC n02be01 MedGen acetaminophen MedATC n02be01 MedGen acetaminophen MedATC n02be01 The CHK file of my qustionnaire (MedicineQues.CHK): MedNvn MUSTENTER COMMENT LEGAL MedGen.rec Show TYPE COMMENT MedGen END MedGen COMMENT LEGAL MedATC.rec Show TYPE COMMENT MedATC END MedATC NOENTER End (The role of the command MUSTENTER and NOENTER is not fully clear to me, However, they have to be included in this fashion) The CHK file of the Brand-Generic database (MedGen.CHK): MedNvn KEY 1 END MedGen KEY 2 END The CHK file of the Generic-ATC database (MedATC.CHK): MedNvn KEY 1 END MedATC KEY 2 END My QESTIONNAIRE file (MedicineQues.QES): MedNvn the name of the Drug ___________________ MedGen The Generic name ___________________ MedATC The ATC code _____________ AnyFild Any field # *¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-

1 0

String functions
by epidata-list＠lists.umanitoba.ca 11 Jan '07

11 Jan '07

Hello Epidata Listers. My colleague and I are new to the data entry development game and can't figure out the string functions. Our study id is a combination of one letter and 3 numbers. I'd like for the letter to always be capitalized. It seems that the following might be appropriate somehow: function Upper(S: string): string Returns a string containing the same text as S, but with all letters converted to upper case. but I don't understand how it works. Where do I put the function? Do I replace "S" with the variable name "id"? I've tried several variations but since I don't understand the logic, I don't know how to debug my syntax errors. I'd appreciate any help you could give! Thanks, Kristine ------------------------------------- Kristine Hopkins, Ph.D. Population Research Center 1 University Station, G1800 Austin, TX 78712 ph: 512.471.8313 fax: 512.471.4886

1 1

(sin asunto)
by epidata-list＠lists.umanitoba.ca 10 Jan '07

10 Jan '07

1 0

Regarding automatically filling of fields
by epidata-list＠lists.umanitoba.ca 09 Jan '07

09 Jan '07

Once again This syntax work when data entered to one field and a second field being automaticaly filled up. What is the syntax for a following third field (ATC code) to be filled after the entering into the first field??? The CHK file of my qustionnaire (MedicineQues.CHK): MedNvn MUSTENTER COMMENT LEGAL MedGenATC.rec SHOW TYPE COMMENT MedGen END MedGen NOENTER END The CHK file of the Brand-Generic-ATC database (MedGenATC.CHK): MedNvn KEY 1 END MedGen KEY 2 END My QES file (MedicineQues.QES): MedNvn the name of the Drug ___________________ MedGen The Generic name ___________________ MedATC The ATC code _____________ AnyFild Any field # and my REC of the Brand-Generic-ATC database (MedGenATC.REC): (I took only 6 cases for illustration) MedNvn Aspirin MedGen acetylic salicylic acid n02ba01 MedNvn Beuron MedGen acetaminophen n02be01 MedNvn Efferalgan MedGen acetaminophen n02be01 MedNvn Panadol MedGen acetaminophen n02be01 MedNvn Paralen MedGen acetaminophen n02be01 MedNvn Tyelenol MedGen acetaminophen n02be01 *¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-

1 2

Regarding automatically filling of fields
by epidata-list＠lists.umanitoba.ca 08 Jan '07

08 Jan '07

The CHK file of my qustionnaire (MedicineQues.CHK): MedNvn MUSTENTER COMMENT LEGAL MedGenATC.rec SHOW TYPE COMMENT MedGen END MedGen NOENTER END The CHK file of the Brand-Generic-ATC database (MedGenATC.CHK): MedNvn KEY 1 END MedGen KEY 2 END My QES file (MedicineQues.QES): MedNvn the name of the Drug ___________________ MedGen The Generic name ___________________ MedATC The ATC code _____________ AnyFild Any field # and my REC of the Brand-Generic-ATC database (MedGenATC.REC): (I took only 6 cases for illustration) MedNvn Aspirin MedGen acetylic salicylic acid n02ba01 MedNvn Beuron MedGen acetaminophen n02be01 MedNvn Efferalgan MedGen acetaminophen n02be01 MedNvn Panadol MedGen acetaminophen n02be01 MedNvn Paralen MedGen acetaminophen n02be01 MedNvn Tyelenol MedGen acetaminophen n02be01 *¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-

1 0

Regarding automatically filling of fields by a helping database
by epidata-list＠lists.umanitoba.ca 07 Jan '07

07 Jan '07

*** *** *** Comments to the suggested procedures: Regarding Jens Lauritsens' comment- I am working with a great number of 'brand names' of about 3.000. It will be a very big CHK file and a lot of work to do to arrange the file. I did not tried the model. As to Hans' comment- I tried the model and used the following syntax in the MedicineQues.CHK file: MEDNVN MUSTENTER COMMENT LEGAL AutoFillMedGenATC.rec SHOW TYPE COMMENT MedGen END MedGen NOENTER END My NameGenericATC.CHK looked like this: MedNvn KEY 1 END GenNvn KEY 2 END My MedicineQues.QES file looked like this: MedNvn the name of the Drug ___________________ MedGen The Generic name ___________________ MedATC The ATC code _____________ and my NameGenericATC.REC looked like this: MedNvn Aspirin MedGen acetylic salicylic acid n02ba01 MedNvn Beuron MedGen acetaminophen n02be01 MedNvn Efferalgan MedGen acetaminophen n02be01 MedNvn Panadol MedGen acetaminophen n02be01 MedNvn Paralen MedGen acetaminophen n02be01 MedNvn Tyelenol MedGen acetaminophen n02be01 However, I could not find out to get the ATC codes to appear on the MedATC field.

1 1

Generic and brand names
by epidata-list＠lists.umanitoba.ca 03 Jan '07

03 Jan '07

Make a QES files with three fields: brandname ___________ genername ___________ otherfield _ Make your CHK file: brandname MUSTENTER COMMENT LEGAL brandgeneric.rec SHOW TYPE COMMENT genername END genername NOENTER END otherfield MUSTENTER END In the field "brandname" you refer to another REC file "brandgeneric.rec". This latter REC files has 2 fields: brand ________ generic ________ and the BRANDGENERIC.CHK file must be: brand KEY 1 END generic KEY 2 END This presumes that you have imported the list of brandnames with the corresponding generic name into the BRANDGENERIC.REC file, e.g. brand Aspirin generic acetylic salicylic acid brand Beuron generic acetaminophen brand Efferalgan generic acetaminophen brand Panadol generic acetaminophen brand Paralen generic acetaminophen brand Tyelenol generic acetaminophen If the data entry person starts entering, the list will show as a labelblock and starting writing will go to the brandname, once reached, ENTER suffices, the brandname is entered into the field BRANDNAME and the field GENERNAME is automatically completed. Hope this helps, Hans Just arrived on the list. I am about to construct a questionnaire on Epi-Data. Never worked with = it before, but it seems to be quite straight forward simple, as long as = the requirements are simple However, for some years ago I was constructing similar questionnaire on = the Paradox DB. It was possible to simplify the type work by cross = tabulating. e.g. Instead of typing the patients address, telephone number, and so = forth, these data was auto-filled in the database that was linked to = another database with the mentioned informations. I create a medication questionnaire. As the patients normally knows the = 'trade names', and I am interested in the 'generic names' (as many of = you knows e.g. one of the most used pain killers acetaminophen exists as = multiple brands). I have a database consisting of these two variables.=20 It will be 100.000 times easier for the persons typing the = questionnaires to type one of the brand names of acetaminophen and the = generic name automatically will be filled. Is it possible to create this lin on the Epi-data?? -- Hans L Rieder, MD, MPH Jetzikofenstr. 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org

1 0

looking up information based on entry in a field
by epidata-list＠lists.umanitoba.ca 03 Jan '07

03 Jan '07

It is quite easy to set up a system where information is converted based on input in a field Look in the help file for EpiData Entry under "comment legal". e.g. qes: v1 entered information _______________________ v2 converted information ________________________________ chk file: v1 comment legal AMA "Aminoacetophen" ABA "Aminoacetophen" PC "Penicillin A" PC1 "Penicillin A" end type comment v2 end v2 noenter end if you enter "AMA" or "ABA" in v1 then the equivalent "AminoAcetophen" will be copied into field v2. Kind regards and happy new year to all Jens Lauritsen EpiData Association

1 0

Cross tabulating
by epidata-list＠lists.umanitoba.ca 02 Jan '07

02 Jan '07

Just arrived on the list. I am about to construct a questionnaire on Epi-Data. Never worked with it before, but it seems to be quite straight forward simple, as long as the requirements are simple. However, for some years ago I was constructing similar questionnaire on the Paradox DB. It was possible to simplify the type work by cross tabulating. e.g. Instead of typing the patients address, telephone number, and so forth, these data was auto-filled in the database that was linked to another database with the mentioned informations. I create a medication questionnaire. As the patients normally knows the 'trade names', and I am interested in the 'generic names' (as many of you knows e.g. one of the most used pain killers acetaminophen exists as multiple brands). I have a database consisting of these two variables. It will be 100.000 times easier for the persons typing the questionnaires to type one of the brand names of acetaminophen and the generic name automatically will be filled. Is it possible to create this lin on the Epi-data?? Thanks *¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-

1 0

Cross tabulating
by epidata-list＠lists.umanitoba.ca 01 Jan '07

01 Jan '07

Just arrived on the list. I am about to construct a questionnaire on Epi-Data. Never worked with it before, but it seems to be quite straight forward simple, as long as the requirements are simple. However, for some years ago I was constructing similar questionnaire on the Paradox DB. It was possible to simplify the type work by cross tabulating. e.g. Instead of typing the patients address, telephone number, and so forth, these data was auto-filled in the database that was linked to another database with the mentioned informations. I create a medication questionnaire. As the patients normally knows the 'trade names', and I am interested in the 'generic names' (as many of you knows e.g. one of the most used pain killers acetaminophen exists as multiple brands). I have a database consisting of these two variables. It will be 100.000 times easier for the persons typing the questionnaires to type one of the brand names of acetaminophen and the generic name automatically will be filled. Is it possible to create this lin on the Epi-data?? Thanks *¸..· ´¨)) -:¦:- * ¸.·´ . (( -:¦:- * Ishay * -:¦:- ´·.. ..·´ ((¸¸.·´* -:¦:-

1 0