January 2007 - EpiData-list - University of Manitoba Mailing Lists

EpiData-list
by epidata-list＠lists.umanitoba.ca 24 Jan '07

24 Jan '07

Hello, For French users Je n'ai pas eu beaucoup de chances avec mon precedent mail, proposant une eventuelle mutualisation des personnes pour la realisation de guides d'aide a l'utilisation de EPIDATA. J'ai finalement realise trois guides : - Un 8-pages de prise en main rapide - Un guide pour l'analyse seule - Un guide pour le controle des donnees avec un mot sur les fichiers relationnels Ces trois documents ne peuvent être joints a ce mail (taille bornee). Vous pourrez les trouver sur le site internet du Reseau Securite-Naissance des Pays de la Loire www.reseau-naissance.fr Je reste a votre disposition Bernard Branger branger-bono(a)wanadoo.fr Message redige sans accent

1 0

[EpiData-list] Importing other file formats (eg SPSS) to create REC, CHK and QES files
by epidata-list＠lists.umanitoba.ca 23 Jan '07

23 Jan '07

Hello, I know that EpiData has the ability to output data in SPSS format (a TXT file and an SPS file which can be run to create a SAV file) - is it possible to reverse this process and either use a SAV file or a SPS/TXT combination to create REC and CHK files (and ideally even the QES file to go with them)? I'm also interested if I could generate REC/CHK files from other file formats, such as Triple-S (and output to this too) - what options are there currently for doing this. If nothing, are any being worked on or considered for implementation in future versions? I would be interested in helping with developing these things if that is possible or would help also. Thanks, Charity

1 6

command labelvalue in analysis
by epidata-list＠lists.umanitoba.ca 22 Jan '07

22 Jan '07

A user wrote: "I discovered this link http://www.epidata.dk/downloads/docs/commands.htm" The link is outdated and has been deleted today. The overview of the latest commands in most recent development versions can always be found at "http://www.epidata.dk/commands.htm" However the release of next version of analysis will not take place until I find it sufficiently stable for general testing and usage. At that point you will find a copy on the testing page: http://www.epidata.dk/testing.php I reject telling when a given release is going to be made - since this is basically unknown. Unfortunately I am somewhat naive in this respect, since severe problems have been showing up during the major rewrite ongoing since release of v1.0 build 68. The list will be informed when the release is ready. The same answer applies to the other question: > When I calculate proportions, how to have Interval of confaince? > In Epiinfo, the command is Freq "Var"/C!! > Speed of development can usually be increased by confirmed donations to the EpiData Association. At this moment the latest donations have been given by the World Lung Foundation and the Swiss MPH education organisation. Thanks for the donations. Regards Jens Lauritsen EpiData Association

1 0

Bug of Unique Key Field
by epidata-list＠lists.umanitoba.ca 22 Jan '07

22 Jan '07

Dear Epidata Team Friends, We have a unique field known as RECNO. We enter the number manually by looking at the latest RECORD NUMBER displayed at the bottom of the screen. When we enter the RECNO equal to the RECORD NUMBER. Displayed on the screen, a warning Dialogue box is displayed. Warning Duplicate Key in RECNO Value already entered in Record Number #4284 Go to Record #4284? Yes No When I press the yes button, Record Number is 4284 not 4285 as shown in the warning dialogue box. When I tested higher numbers, same warning message is displayed? Is it a bug or some solution is possible ? Please help us as we are waiting. Dr. Shavinder Singh

1 0

Interval of Confiance
by epidata-list＠lists.umanitoba.ca 22 Jan '07

22 Jan '07

Hello, When I calculate proportions, how to have Interval of confaince? In Epiinfo, the command is Freq "Var"/C!! Thanks ___________________________________________ Dr Jean-Paul DIBY-KONAN Médecin Santé Publique MCM Santé de la Reproduction Institut Médecine Tropicale Kapucinessenstraat 8 B-2000 Anvers Belgique ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com

1 0

Command labelvalue
by epidata-list＠lists.umanitoba.ca 21 Jan '07

21 Jan '07

Hi, I looked on the site of epidata, in the section Documentation and on Commands and Functions in EpiData Analysis, i discovered this link http://www.epidata.dk/downloads/docs/commands.htm So in label Dates, there is labelvalue and missingvalue (new). I tried to carry out these orders here is the message which is displayed "Unknown Command". Then what is to be done? Thanks ___________________________________________ Dr Jean-Paul DIBY-KONAN Médecin Santé Publique MCM Santé de la Reproduction Institut Médecine Tropicale Kapucinessenstraat 8 B-2000 Anvers Belgique ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com

1 0

RE: AW: [EpiData-list] chk file size
by epidata-list＠lists.umanitoba.ca 19 Jan '07

19 Jan '07

In my experience the .chk files do get truncated at 64 kb when used with the .qes file, even when it was larger. My work-around is in my opinion not very elegant but it works: I split up the .qes and .chk files in two and have them linked by RELATE. Henriette Jansen -----Original Message----- From: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Sent: 18 January 2007 22:52 To: epidata-list(a)lists.umanitoba.ca Subject: Re: AW: [EpiData-list] chk file size My understanding from Jens is that the limitation had to do with using the internal editor. My .chk files often are a good deal longer than 64kb and I don't use the internal editor. But as always, testing is always the best advice. Richard NIMH epidata-list(a)lists.umanitoba.ca wrote: I think there is an issue whether EpiData , once it applies the *.chk file, truncates the *.chk file at 64Kb even if it was larger (because it was written in an other editor ). I am unsure whether it truncates or not. You should test it before relying on writing a longer one. marcel -----Ursprüngliche Nachricht----- Von: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Gesendet: Donnerstag, 18. Januar 2007 11:15 An: epidata-list(a)lists.umanitoba.ca Cc: Kristine Hopkins Betreff: RE: [EpiData-list] chk file size Hi; CHK files can be edited with any text editor, provided the syntax is respected. I'm using metapad (freeware, can be download at http://www.liquidninja.com/metapad/). It's small and very powerful. Gilles Delmas -----Message d'origine----- De : epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Envoyé : mercredi 17 janvier 2007 03:15 À : epidata-list(a)lists.umanitoba.ca Cc : Kristine Hopkins Objet : [EpiData-list] chk file size Hello, I have encountered a problem with the size of my check file. I need to exceed the limit of 64Kb to include all the checks I want. Is there a way to get around this limitation? The manual says that "File size for CHK or QES files cannot exceed 64Kb in size if you work in the editor with that file." Is there another place to work in other then the editor? Any help is appreciated! Cate McNamee _______________________________________________ EpiData-list mailing list EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list --------------------------------- Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

1 0

chk file size
by epidata-list＠lists.umanitoba.ca 18 Jan '07

18 Jan '07

Hello, I have encountered a problem with the size of my check file. I need to exceed the limit of 64Kb to include all the checks I want. Is there a way to get around this limitation? The manual says that "File size for CHK or QES files cannot exceed 64Kb in size if you work in the editor with that file." Is there another place to work in other then the editor? Any help is appreciated! Cate McNamee

1 4

How to - analysis: Routine reporting (Check if count is larger than 0)
by epidata-list＠lists.umanitoba.ca 17 Jan '07

17 Jan '07

When doing routine reporting we never know in advance if there are some observations for a given table in analysis. Therefore: read rawfile_from_patientsystem.csv /close means y sex would stop if no persons had any data in variable y The technique in analysis to control this is: read rawfile_from_patientsystem.csv /close * first count the number (with /q the result is not shown) count if y <> . /q imif $count > 0 then means y sex else type "No data in y or sex" endif Another useful technique is to find the period in the data. By sorting on the date variable and save the result as a constant this can be used in a "report". read rawfile_from_patientsystem.csv * sort on a given variable containing date: sort entrydate define first ________________ global define last ________________ global first = string(vmeb001[1]) count last = string(vmeb001[$count]) type "test - @first - @last" /h3 If one adds then "cls" to clear the screen or "set echo = off", then only the result of the type command is shown. But only do this when it is all working. I am writing on a manual of "how to write menusystems" for release later this year. The techniques above will be part of that. Jens Lauritsen EpiData Association

1 0

Reading and closing files with EpiData
by epidata-list＠lists.umanitoba.ca 14 Jan '07

14 Jan '07

Dear Marc, > Also, I did not follow why the Read opened this file, and then I could > not close it? > > read "c:\epi_info\hosp\hsample.mdb > malformed string > . read "c:\epi_info\hosp\hsample.mdb" > No, data will be lost - Close first > . close read "c:\epi_info\hosp\hsample.mdb" > Syntax error It seems to me that you are triying to open an ACCESS file using EPiData. EpiData does not read ACCESS files. Still it trys, and the consequence is this: malformed string message. Once you have open a data set, Epidata does not allow you to open another without closing the first. This is because EpiData trys to prevent you of losing any changes you have done in your first data set. Only if you activily close you first data set you can open a second. The reason for the third message: Syntax error is that the syntax for closing a data set is just CLOSE. I hope it helps. Pedro Arias EpiData Translator > Thanks > Marc > L.A. > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 39, Issue 9 > *******************************************

1 0

Read files
by epidata-list＠lists.umanitoba.ca 14 Jan '07

14 Jan '07

EpiData Analysis does not read Access files, export it into a format that can be read (REC, CSV, DBF) Hans read "c:\epi_info\hosp\hsample.mdb malformed string . read "c:\epi_info\hosp\hsample.mdb" No, data will be lost - Close first . close read "c:\epi_info\hosp\hsample.mdb" Syntax error Thanks Marc L.A. -- 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

quesitons re Browse and Read/Close
by epidata-list＠lists.umanitoba.ca 13 Jan '07

13 Jan '07

I just started using Epidata. In my first Browse I could not move the screen completely to the right to see the command. Is there a limit to the number of characters the screen can display on any given line? Also, I did not follow why the Read opened this file, and then I could not close it? read "c:\epi_info\hosp\hsample.mdb malformed string . read "c:\epi_info\hosp\hsample.mdb" No, data will be lost - Close first . close read "c:\epi_info\hosp\hsample.mdb" Syntax error Thanks Marc L.A.

1 0

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

13 Jan '07

Just a comment to MUSTENTER and NOENTER MUSTENTER prevents people from skipping inadvertently a field NOENTER prevents people from getting into the field and inadvertently change it (The role of the command MUSTENTER and NOENTER is not fully clear to me, = However, they have to be included in this fashion) To Jamie, Jens Lauritsen, Hans and all of you that follow this thread = and came with many helpful suggestions 'Thanks'. Hans -- 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

Re: Regarding automatically filling of fields and colloborative efforts
by epidata-list＠lists.umanitoba.ca 13 Jan '07

13 Jan '07

1. Regarding automatically filling of fields > 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. > This is a very good example of how "good examples" develop with assistance. Please wrap up this example and send for inclusion as a worked example for placement on www.epidata.dk/examples.php E.g. just a zip file with the qes, chk and rec files and a pdf file showing the screen. Much like the "Yves" example, a good example was created. By combining efforts in this way many people learn and gets inspiration. Another way of giving inspiration is to work out "flyers" in collaboration with me, such as http://www.epidata.dk/php/downloadc.php?file=epidataflyer_general.pdf Projects or institutions having examples or ideas are much welcomed to suggest this. Best by writing to "info at epidata.dk " I hope during the 2007 it will be possible to get a WIKI started with mutual responsibility among users. Some aspects of this has been started, but the whole organisation is not ready for general use yet. A WIKI is an open editing system based on contributions from a broad base of users. Examples are: www.wikipedia.org, http://www.freepascal.org/wiki or https://wiki.ubuntu.com/. An example for use in EpiData would be introduction texts developed in local language, such as the one announced earlier on epidata-list by Bernard Branger and located at http://www.reseau-naissance.fr/medias/epidata_guide_2006.pdf and http://www.reseau-naissance.fr/medias/epidata_guide_controle.pdf which could be kept locally and then with a link in the wiki or added as text to the wiki. The difference from text on the EpiData main site is that the editing and placement on the WIKI needs no work from my part. In contrast to the main site where I (or another dedicated person) have to do something to add texts. Kind regards Jens Lauritsen EpiData Association

1 0

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