- EpiData-list - University of Manitoba Mailing Lists

Re: [EpiData-list] Program simulated data in EpiData (Analysis)
by epidata-list＠lists.umanitoba.ca 25 May '08

25 May '08

Greetings SK, [This may be a repeat -- first posting didn't seem to get through] I like to use a little program by Christian Maas to generate data, Random file generator from: http://www.chmaas.handshake.de/delphi/freeware/freeware.htm The command line version can be run from a BAT file containing a statement such as: RndFileC.exe /R=50000 /Z=YYYY/MM/DD /N=4 /F=1,@ /C=15 /F=1,, /B /C=1 /S=14 /B /C=1 /S=14 /F=1,@ /Y=1945,2003 data.txt For example, this generates 50,000 records with the given date format and range, plus other fields. Then import into EpiData. I prefer to set up the EpiData files, enter a few records, and then export them to a CSV file; then make sure you use the same format to generate the random records to import back into EpiData. I have use Maas's program to generate 8,000,000 records (but not this number for EpiData; this was data to analyze using gawk in GNU/Linux). The sort program is real nice, too. Hope this helps, Pete Geddes geddes(a)ix.netcom.com ----- Original Message --------------- Subject: [EpiData-list] Program simulated data in EpiData (Analysis) From: epidata-list(a)lists.umanitoba.ca Date: Sun, 25 May 2008 09:38:58 -0400 To: epidata-list(a)lists.umanitoba.ca > >Dear All > >I was wondering if EpiData Analysis could do simulations: here is what I am contemplating doing; I have created a database of admissions/discharges from a hospital using a standardized register and using EpiData as the software for data entry and ana;ysis. I wish to populate the fields (15 in total, of various types: boolean, categorical with k values, numeric, and date fields) I have created with say N=5,000 observations. The reason I wish to do this is to show the stakeholders (in this case Hospital Managers and Unit Heads) that one could use simple yet effective data entry and analysis software (like EpiData) to monitor and evaluate hospital-based programs. I wanted them to see EpiData in action with the simulated data--starting with EpiData Entry and then with Analysis. > > > >Can simulation be done in Analysis? or should I prepare the dataset with Stata or SAS and then import in EpiData--I am not sure how to do this, but I will search around to see how to get it done? > > > >Thanks, > >SK >

1 0

How to: Simulation with EpiData Analysis
by epidata-list＠lists.umanitoba.ca 25 May '08

25 May '08

Simulation for entry is not that easy. But some tests have been done with "recording software". The results of this could be uploaded if there is an interest. Simulation for analysis is rather simple. The simplest way is: close * generate x empty observations, e.g. 1000: generate 1000 * then generate the variables: e,g, integer sex: gen i sex = 1 if recnumber > 499 then sex = 0 .... continue with other variables. * look also in the help file for: random functions. The extended way is to use the user specified commands. For explanation of this see: The documentation page or the direct download link at: http://www.epidata.dk/php/downloadc.php?file=cmd_command_epidata_analysis.p… Kind regards Jens Lauritsen EpiData Association

1 0

Program simulated data in EpiData (Analysis)
by epidata-list＠lists.umanitoba.ca 25 May '08

25 May '08

Dear All I was wondering if EpiData Analysis could do simulations: here is what I am contemplating doing; I have created a database of admissions/discharges from a hospital using a standardized register and using EpiData as the software for data entry and ana;ysis. I wish to populate the fields (15 in total, of various types: boolean, categorical with k values, numeric, and date fields) I have created with say N=5,000 observations. The reason I wish to do this is to show the stakeholders (in this case Hospital Managers and Unit Heads) that one could use simple yet effective data entry and analysis software (like EpiData) to monitor and evaluate hospital-based programs. I wanted them to see EpiData in action with the simulated data--starting with EpiData Entry and then with Analysis. Can simulation be done in Analysis? or should I prepare the dataset with Stata or SAS and then import in EpiData--I am not sure how to do this, but I will search around to see how to get it done? Thanks, SK

1 1

Default values in boolean fields
by epidata-list＠lists.umanitoba.ca 22 May '08

22 May '08

The simplest solution for default values is to use the chk command "Defaultvalue" Further explanation is shown in the help file. eg qes: v1 my boolean variable <y> v2 ....... etc chk v1 defaultvalue 0 end regards Jens Lauritsen

1 0

improvised checkboxes
by epidata-list＠lists.umanitoba.ca 21 May '08

21 May '08

I understand that epiData does not have checkboxes as such. Therefore the boolean fieldtype is suggested. In order to save time when entering data for certain variables, I would like to have epiData automatically write N, if nothing is entered. Otherwise all dummy variables are created as missing, unless I type "0" or "N" in each field. Is there a way to do this automatically? I already tried MISSINGVALUE N or MISSINGVALUE 0 and AFTER RECORD IF saaadr = . THEN saaadr=0 ENDIF END but unfortunately with no result. Thanks in advance for any suggestion. Marius _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx

1 1

Alyshia Landry is out of the office.
by epidata-list＠lists.umanitoba.ca 16 May '08

16 May '08

I will be out of the office starting 05/16/2008 and will not return until 05/20/2008. If you require immediate assistance, please contact Celina Sousa at extension 5300. Thank-you and have a nice weekend, Alyshia

1 0

Error Message on Values Labels
by epidata-list＠lists.umanitoba.ca 16 May '08

16 May '08

Susan Caplan wrote: 'When I try to enter a string under value label LABEL Label_hablaespan 1 espanol 2 mayormente espanol 3 espanol e ingles igual 4 mayormente ingles 5 ingles solamente END It says Missing label for one or more accepted values. ' Yes, you will get such an error message because some of your value labels have more than one word. When your value label has more than one word, you should use quotes as shown below: LABEL Label_hablaespan 1 espanol 2 "mayormente espanol" 3 "espanol e ingles igual" 4 "mayormente ingles" 5 "ingles solamente" END Also, you don't use legal values and label blocks at the same time. Regards, Biggie, Maseru, Lesotho --------------------------------- Sent from Yahoo! Mail. A Smarter Email.

1 0

Res: EpiData-list Digest, Vol 55, Issue 11
by epidata-list＠lists.umanitoba.ca 15 May '08

15 May '08

Hi Susan Did you try " " ? 1 espanol 2 "mayormente espanol" 3 "espanol e ingles igual" 4 "mayormente ingles" 5 "ingles solamente" Hope this help, Fúlvio Porto Alegre - Brasil ----- Mensagem original ---- De: "epidata-list-request(a)lists.umanitoba.ca" <epidata-list-request(a)lists.umanitoba.ca> Para: epidata-list(a)lists.umanitoba.ca Enviadas: Quinta-feira, 15 de Maio de 2008 14:01:57 Assunto: EpiData-list Digest, Vol 55, Issue 11 Send EpiData-list mailing list submissions to epidata-list(a)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(a)lists.umanitoba.ca You can reach the person managing the list at epidata-list-owner(a)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. value labels error message (epidata-list(a)lists.umanitoba.ca) 2. legal use? (epidata-list(a)lists.umanitoba.ca) 3. combined numeric text variable (epidata-list(a)lists.umanitoba.ca) 4. Re: combined numeric text variable (epidata-list(a)lists.umanitoba.ca) 5. Re: legal use? (epidata-list(a)lists.umanitoba.ca) 6. Re: value labels error message (epidata-list(a)lists.umanitoba.ca) ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list When I try to enter a string under “value label” LABEL Label_hablaespan 1 espanol 2 mayormente espanol 3 espanol e ingles igual 4 mayormente ingles 5 ingles solamente END It says “Missing label for one or more accepted values.” I have tried entering legal values 1-5 and/or omitting values, but I still get this message, which I don’t know how to correct. Susan Caplan Message recieved: The check file C:\Documents and Settings\Susan Caplan\My Documents\database diss\databaseimmigrant.chk contains the following errors: Value is not compatible with this field type in line 33: COMMENT LEGAL USE label_dm2 Value is not compatible with this field type in line 46: COMMENT LEGAL USE label_dm4 LABELBLOCK LABEL label_dm2 lang pref 1. Spanish 2. English END LABEL label_dm4 1. nuevo 2. previa END 1) What is wrong with the field types in the above variables? 2) The above message continues repeating and I am not allowed to edit/revise checks, but must clear all checks to get back into check dialogue Susan I want to create a variable that is numeric ## and text ___________________________ for a fill in response such as “other”. However, a combination of text and numeric within the same variable creates two variables. For statistical purposes I don’t want to opt for text only. Suggestions? Susan Caplan, RN, MSN, FNP-BC Yale University PhD Student in Nursing Susan - glad to see you are using EpiData. I think you just need to look at some of the sample files to get over the initial step of learning some of the syntax. You cannot create a variable of mixed type (##____________). This will always create two variables and this is how you need to set up your file. Although programs like Access will let you create patterns for data entry, they will not let you create mixed type variables. You will find that EpiData has huge advantages. I suggest you just set up your data entry line as follows somevar ##__________________________ EpiData creates two fields (variables), named "somevar" and "somevar01" - may vary depending on your settings. This is actually exactly what you want. You can then set a range or legal values on the ## field to be sure the entry is correct. If you need to combine them into one at some point, this is very easy in EpiData or any other software. In your other postings, there are a couple of things to watch out for - these are explained in the short introduction file. 1) In the check file, text that has any spaces or other special characters must be put into regular quotes 3 "espanol e ingles igual" 2) If your entry field is ##, do not use decimal points in the range or legal values LABEL label_dm2 lang pref 1 Spanish 2 English END While a number of us will be glad to offer help as you get started, I encourage you to look at examples, at the list serv archives and at all of the help files for guidance. Jamie > I want to create a variable that is numeric ## and text > ___________________________ for a fill in response such as “other”. However, a > combination of text and numeric within the same variable creates two variables. > For statistical purposes I don’t want to opt for text only. Suggestions? > > > Susan Caplan, RN, MSN, FNP-BC > Yale University > PhD Student in Nursing 1) The line. lang pref should be marked as a comment with a * sign at the begin of the line 2) the dot after the numbers should be removed. check file : LABELBLOCK LABEL label_dm2 1 Spanish 2 English END LABEL label_dm4 1 nuevo 2 previa END END The type of dm2 and dm4 must be integer of size 1 (#) > Message recieved: > > The check file C:\Documents and Settings\Susan Caplan\My Documents\database > diss\databaseimmigrant.chk contains the following errors: > > > > Value is not compatible with this field type in line 33: > COMMENT LEGAL USE label_dm2 > > Value is not compatible with this field type in line 46: > COMMENT LEGAL USE label_dm4 > > > LABELBLOCK > LABEL label_dm2 > lang pref > 1. Spanish > 2. English > END > LABEL label_dm4 > 1. nuevo > 2. previa > END > > 1) What is wrong with the field types in the above variables? > 2) The above message continues repeating and I am not allowed to edit/revise > checks, but must clear all checks to get back into check dialogue > > > > Susan > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > -- Jean-Marie Chrétien CHU d'Angers - Centre de Recherche Clinique 4 rue Larrey 49933 ANGERS Cedex 9 Tel : 02.41.35.59.76 Fax : 02.41.35.59.68 Dear Susan, You must enclose your labels with double quotes when they contains spaces: 2 "mayormente espanol" ... Jean-Marie Chrétien > When I try to enter a string under “value label” LABEL Label_hablaespan > 1 espanol > 2 mayormente espanol > 3 espanol e ingles igual > 4 mayormente ingles > 5 ingles solamente > END > > It says “Missing label for one or more accepted values.” I have tried entering > legal values 1-5 and/or omitting values, but I still get this message, which I > don’t know how to correct. > > > Susan Caplan > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > -- Jean-Marie Chrétien CHU d'Angers - Centre de Recherche Clinique 4 rue Larrey 49933 ANGERS Cedex 9 Tel : 02.41.35.59.76 Fax : 02.41.35.59.68 Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/

1 0

legal use?
by epidata-list＠lists.umanitoba.ca 15 May '08

15 May '08

Message recieved: The check file C:\Documents and Settings\Susan Caplan\My Documents\database diss\databaseimmigrant.chk contains the following errors: Value is not compatible with this field type in line 33: COMMENT LEGAL USE label_dm2 Value is not compatible with this field type in line 46: COMMENT LEGAL USE label_dm4 LABELBLOCK LABEL label_dm2 lang pref 1. Spanish 2. English END LABEL label_dm4 1. nuevo 2. previa END 1) What is wrong with the field types in the above variables? 2) The above message continues repeating and I am not allowed to edit/revise checks, but must clear all checks to get back into check dialogue Susan

1 1

value labels error message
by epidata-list＠lists.umanitoba.ca 15 May '08

15 May '08

When I try to enter a string under value label LABEL Label_hablaespan 1 espanol 2 mayormente espanol 3 espanol e ingles igual 4 mayormente ingles 5 ingles solamente END It says Missing label for one or more accepted values. I have tried entering legal values 1-5 and/or omitting values, but I still get this message, which I dont know how to correct. Susan Caplan

1 1