List/export data using record filter on dates
From a datafile, how do I list/export cases with dates between 1/1-31/12
2005. I try to use the record filter function but get the error message "...not a valid boolean expression". The Field type DD/MM/YYYY.
Nikolai Stenfors
It seems the filter in EpiData Entry will not accept strings. you can easily do this in Analysis
read file.rec select datefield > dmy(31,12,2004) and datefield < dmy(1,1,2006) * export records to new .rec file savedata newfile * list some fields list f1 f2 f3 datefield etc
Jamie
Nikolai wrote:
From a datafile, how do I list/export cases with dates between 1/1-31/12
- I try to use the record filter function but get the error message
"...not a valid boolean expression". The Field type DD/MM/YYYY.
Easy! Thanks!
Nikolai
epidata-list@lists.umanitoba.ca Skriver:
It seems the filter in EpiData Entry will not accept strings. you can easily do this in Analysis
read file.rec select datefield > dmy(31,12,2004) and datefield < dmy(1,1,2006)
- export records to new .rec file
savedata newfile
- list some fields
list f1 f2 f3 datefield etc
Jamie
Nikolai wrote:
From a datafile, how do I list/export cases with dates between
1/1-31/12
- I try to use the record filter function but get the error message
"...not a valid boolean expression". The Field type DD/MM/YYYY.
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
participants (1)
-
epidata-list＠lists.umanitoba.ca