- EpiData-list - University of Manitoba Mailing Lists

How to: How is sort order of tables defined ? (get tables in right order)
by epidata-list＠lists.umanitoba.ca 29 Oct '05

29 Oct '05

One way of getting other people to see problems is to have analysis creating random data with a combination of the command generate (which produces an empty data file) and the random functions. Then we do not need the attached files. The reason for NOT allowing attachments is that this is a very good way of protecting all on the list from virus spreading E.g. for the question from today run these commands: First: create a chk file with the labels: ....................... t.chk ................ labelblock label s 1 "London" 2 "Copenhagen" 3 "Madrid" 4 "New Delhi" 5 "Madras" 6 "Pretoria" 7 "Kiev" 8 "Hong Kong" 9 "Melbourne" 10 "Sao Paolo" 11 "Santiago" 12 "Ottawa" 13 "New Orleans" 14 "Bangkok" 15 "Honolulu" 16 "Havana" 0 "Oslo" 17 "Odense" 18 "Paris" 19 "Budapest" end end sitecode comment legal use s end sex comment legal 0 male 1 female end end ..... save the text above as t.chk ........................ ............ Then create a pgm file: t.pgm: ................................ * Example file for creation of test data: close * create an empty data set with 1000 observations: generate 1000 define sex # define sitecode ## define sitecode2 ## * now assign values to the variables (random numbers) sex = ran(2) // sex will get numbers 0 and 1 sitecode = random(20) // sitecode will get numbers from 0 to 19 sitecode2 = sitecode savedata t * Now we have saved a data file with 1000 numbers, * but we need to read it again to get the labels read t /close * turn on labels, but turn off numbers for the tables: set table label = on set table value = off tab sex sitecode tab sex sitecode2 * notice that the order is the same as the numerical code for both variables * now we also turn on the numbers for the sitecode: set table value = on tab sex sitecode ................................ end t.pgm When you run the t.pgm you will notice that the first table of sex and sitecode shows this: SEX SITECODE male % female % Total % Oslo 25 {52.1} 23 {47.9} 48 {100.0} London 26 {48.1} 28 {51.9} 54 {100.0} .... snip ....................... Whereas the last with the values turned on shows: set table value = on tab sex sitecode SEX SITECODE 0 male % 1 female % Total % 0 Oslo 25 {52.1} 23 {47.9} 48 {100.0} 1 London 26 {48.1} 28 {51.9} 54 {100.0} 10 Sao Paolo 26 {47.3} 29 {52.7} Which means that for crosstables there is apparently a sorting going on on the first column. Notice that the two variables sitecode and sitecode2 are of type numerical. If we instead had used string variables: define v2 __ v2 = string(sitecode) tab v2 * then the order of v2 would be sorted meaning the "0 oslo - 1 london - 2 sao paolo" sequence * but without the text. To remedy this the trick would be to say: v2 = " " + v2 if length(trim(v2)) < 2 Then a new "tab v2" would show the correct table ------------------------------------------ Lesson: Obviously more user control of sort order of cross tables is on the wish list. But the feature is not part of the current most wanted list from my point of view. We have been experimenting a bit with sorting, but it is not all that easy. By converting btw. variable types and turning values and labels on and off you can get a lot of control as it is now. A feature which is expected to be available later this year is to be able to take the text label from a variable and save in a string variable, e.g. v2string = label(sitecode) or v2string = string(sitecode) + label(sitecode) (this is not implemented now) An undocumented sorting feature is available - but will not be documented until I am sure how to control sorting. Users are welcome to use it. The table will be sorted in reverse numerical order. But the problem with labels and values above persist. table sex v2 /rd or tab sex v2 /Rowdes Jens Lauritsen EpiData Association > 1. have database using .chk which contains a LABELBLOCK > the LABELBLOCK was constructed 1-16 with names assigned to each(of coourse) > 2. ran Analysis and issued the command TABLES SEX SITECODE > 3. result was what appeared to be a random display of SITECODE using the LABELs assigned > 4. it turned out to be the problem with the number ordering > 1 > 10 > 11 > 12 > 13 > 14 > 15 > 16 > 2 > 3 > 4 > 5 > 6 > 7 > 8 > 9 > --so, i suggest either an alphabetc listing of labels or in order it was created 1-16 etc. > --when i removed the LABELBLOCK the output was 1-16 and it should be. also, i noticed that > another person is having the same issue with the FREQ resulting in error 'Too Many Catagories" > thanks, kelly > >

1 0

TABLES OUTPUT
by epidata-list＠lists.umanitoba.ca 29 Oct '05

29 Oct '05

greetings. i was going to send 2 .doc files demonstrating the following 'problem' but, they were more than 25k. 1. have database using .chk which contains a LABELBLOCK the LABELBLOCK was constructed 1-16 with names assigned to each(of coourse) 2. ran Analysis and issued the command TABLES SEX SITECODE 3. result was what appeared to be a random display of SITECODE using the LABELs assigned 4. it turned out to be the problem with the number ordering 1 10 11 12 13 14 15 16 2 3 4 5 6 7 8 9 --so, i suggest either an alphabetc listing of labels or in order it was created 1-16 etc. --when i removed the LABELBLOCK the output was 1-16 and it should be. also, i noticed that another person is having the same issue with the FREQ resulting in error 'Too Many Catagories" thanks, kelly

1 0

hi Jamie
by epidata-list＠lists.umanitoba.ca 29 Oct '05

29 Oct '05

please send email address.... keb1(a)cdc.gov -----Original Message----- From: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Sent: Wed 10/26/2005 6:26 PM To: epidata-list(a)lists.umanitoba.ca Cc: Subject: [EpiData-list] how do you get the file to test the problem? Use EpiData to archive the file - it will be a fraction of the original size. You an do this from the Tools menu. If still too large, then we'll have to exchange e-mail addresses off the list somehow Jamie Hockin Public Health Agency of Canada

1 0

Administrative comments on recent issues on EpiData-List
by epidata-list＠lists.umanitoba.ca 27 Oct '05

27 Oct '05

Good colleagues. A few administrative issues: 1. The list has been set up to enhance communication by e-mail and to limit size of each posting. For users with fast internet size of a mail is not a concern, but for people on slow modem lines large mails creates large problems. So as of now the following rules guide the list: a. Attachments must be small b. Text in e-mail must be small. A combined limit of 25kb has been defined. A few days back a user attached a rec file with the size of almost 1mb which is far exceeding this size. Individual users can exchange large attachments outside the list directly as suggested by Jamie Hockin. 2. Only certain attachments are allowed, e.g. small rec, chk and qes files. 3. Minimise the number of lines when you answer or comment on other mails. If a user asks a question - then on the reply only keep the minimal part indicating the topic of the question and reply. Otherwise the complete originating mail can be repeated several times. 4. Bouncing. When a person has an automatic mail saying e.g. "I am out of office please ....." then when a notice from the list comes to that person a message is sent to the person. The automatic message is sent back to the list, which then replies to the user etc. So if no mechanism controls several hundred mails can bounce back and forth. Therefore some users will experience to be automatically signed off the list. This is not a censorship or similar but a mechanism to avoid that everyone gets many "I am out of office..." messages. If you are excluded by "bounce-control" then just sign on to the list again when you are back from the leave. Or maybe create a different e-mail account which you use for receiving list messages. 5. Write in a specific and short manner and protect your e-mail adress You should be aware that messages you send to the list are: - distributed to all members (currently nearing 200) - is kept as part of the archive and is available for searching on internet. So to minimise the chance that your e-mail is trapped and used in a virus spread do not write it directly if you wish to receive personal mails, but write something like xxx at yyyy zz or similar. instead of xxx(a)yyyy.zz 6. Only users who are members of the list can submit messages. The first message by a new list member is sent to list administrators for approval. We could turn this off, but it will result in advertisements or spam messages every so often. I assume list members appreciate the principles above, but I am willing to discuss some of them. E.g. the size of allowed attachments and mails. Kind regards Jens Lauritsen EpiData Association

1 0

New version 1.0 celebrations and few suggestions
by epidata-list＠lists.umanitoba.ca 27 Oct '05

27 Oct '05

Dear Jens and other friends of Epidata Team, I have just joined the list last week. First of all congratulations for the excellent software developed maintaining the simplicity of EPI6. Good graphic are good addition to that simplicity. Fine controls of percents in the Tables command are just superb. The wishlist is long and it takes lot of effort to fulfil that. However few suggestions; a. Multiple Bar Charts which can depict gender comparisons of a variable in the same graph. b. Freq command with switches such as freq v1 sum=v2, /n /p etc. c. Combine command. d. Freq command requires some corrections as simple freq command of a variable gives an error message "Too many categories". e. In the long run 3D graphic for appropriate data. Please keep up this good work. Sincerely, Dr. Shavinder Singh Department of Community Medicine,

1 0

how do you get the file to test the problem?
by epidata-list＠lists.umanitoba.ca 26 Oct '05

26 Oct '05

Use EpiData to archive the file - it will be a fraction of the original size. You an do this from the Tools menu. If still too large, then we'll have to exchange e-mail addresses off the list somehow Jamie Hockin Public Health Agency of Canada

1 0

variables COMMAND in Analysis
by epidata-list＠lists.umanitoba.ca 26 Oct '05

26 Oct '05

greetings. i just used the variables command in Analysis and the output results were a little surprising. the Value Lable field display was as follows: 1 = a 10 = 25 11 = 26. 19 = 29 2 = b 20 = 30 The Freq or tables command had the same issue at one time. we had this discussion about why before. 1 2 3 4 etc. is a better output in the end. -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca on behalf of epidata-list-request(a)lists.umanitoba.ca Sent: Wed 10/26/2005 10:12 AM To: epidata-list(a)lists.umanitoba.ca Cc: Subject: EpiData-list Digest, Vol 24, Issue 14 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..."

1 0

tried to send but Moderator said no files sze is to big(685KB). how do you get the file to test the problem?
by epidata-list＠lists.umanitoba.ca 26 Oct '05

26 Oct '05

-----Original Message----- From: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Sent: Wed 10/26/2005 9:21 AM To: epidata-list(a)lists.umanitoba.ca Cc: Subject: [EpiData-list] Analysis read time and "too many catagories" greetings. i have atached a .rec file with 165,905 records, each 44 bytes. (1) it takes EpiAnalysis 10 seconds to open compared to instant availability in Epi6. why so slow? (2) using EpiAnalysis FREQ DATE resulted in error... "Too Many Catagories", no output. why??? (3) using Epi6 time for FREQ DATE was 1.9 seconds. slowness we can perhaps tolerate but no output on FREQ may be an issue. Or, it could be ther user. thank you and stay safe, kelly -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca on behalf of epidata-list-request(a)lists.umanitoba.ca Sent: Tue 10/25/2005 1:01 PM To: epidata-list(a)lists.umanitoba.ca Cc: Subject: EpiData-list Digest, Vol 24, Issue 13 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..."

1 0

Analysis read time and "too many catagories"
by epidata-list＠lists.umanitoba.ca 26 Oct '05

26 Oct '05

greetings. i have atached a .rec file with 165,905 records, each 44 bytes. (1) it takes EpiAnalysis 10 seconds to open compared to instant availability in Epi6. why so slow? (2) using EpiAnalysis FREQ DATE resulted in error... "Too Many Catagories", no output. why??? (3) using Epi6 time for FREQ DATE was 1.9 seconds. slowness we can perhaps tolerate but no output on FREQ may be an issue. Or, it could be ther user. thank you and stay safe, kelly -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca on behalf of epidata-list-request(a)lists.umanitoba.ca Sent: Tue 10/25/2005 1:01 PM To: epidata-list(a)lists.umanitoba.ca Cc: Subject: EpiData-list Digest, Vol 24, Issue 13 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..."

1 0

Using Epidata for a central server
by epidata-list＠lists.umanitoba.ca 26 Oct '05

26 Oct '05

Hello 1.About having a central server, please refer to the website and read the limitation of Epidata. 2.Well you can use the qes for data management or also use the option of preparing one data screen(rec file)and use the option of copy structure which is located at the tools menu.The advantage is that; 1. It is fast 2. There is no need to prepare another check. With these option, data entry staff can entry data for you and you have to merge them to have a collective data either at epidata or using spss. Using text fields.It is possible to enter open-ended questions and narrative with Epidata but it limitatiton is that it takes up to 80 characters whilst that of spss DE takes about 256 characters SEDZRO KOJO MENSAH P.O.Box AS 387 Ashaiman -Tema Ghana House : +233-22-300789 MOBILE : +233-244-458788 Homepage http://rastafarionline.com/rasbesa Open WebMail Project (http://openwebmail.org) ---------- Original Message ----------- From: epidata-list-request(a)lists.umanitoba.ca To: epidata-list(a)lists.umanitoba.ca Sent: Tue, 25 Oct 2005 12:01:20 -0500 (CDT) Subject: EpiData-list Digest, Vol 24, Issue 13 > 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..." ------- End of Original Message -------

1 1