[EpiData-list] Date Range selection in Epi Analysis

[epidata-list at lists.umanitoba.ca]

Hi Shavinder,

The problem is not with your dates, but with PQ. Use the following syntax:

IF ATTDATE .... THEN PQ=TRUE ELSE PQ=FALSE

or

PQ = (attdate>dmy(17,4,2005)) and (attdate<dmy(19,4,2005))

The latter gets around having to put in the TRUE/FALSE values altogether 
since the result of everything to the right of the = is a boolean.

FREQ PQ will show values of Y and N, but will expect TRUE and FALSE in 
LET statements. In general Boolean variables are not supported the way 
they were in EpiInfo, but this is probably a good thing. Using numeric 
(0,1) or text ("Y", "N") is often better.

In the third IF statement you are missing an >

You can also use the function dmy(1,1,2006) in place of 
date("01/01/2006","mdy")

Jamie Hockin
Public Health Agency of Canada

Shavinder wrote:
> The error messages received on the EpiAnalysis screen after running the command given,  are given below; 
>
>
> *TBQ.PGM (Updated on 15th August 2006)
> *Program gives the QUARTERLY status report of Tuberculosis of area.
> READ "d:\epi6\FGTRY\TB2000.REC"
> SET STATISTICS=OFF
>
> *Types the DATE RANGE of ATTDATE 3 months prior to beginning of present Quarter.
>
> *defines the time interval of 3 months prior to present Quarter.
>    DEFINE PQ <Y>
>
> IF ATTDATE > date("01/01/2006","mdy") AND  < date("03/30/2006",mdy") THEN LET PQ="Y" ELSE LET PQ="N"
>
>  Error Massages in Epi Analysis;
>   Syntax Error
>   Script resulted in errors
>   Operation aborted 
>
>
> IF (ATTDATE > date("01/01/2006","mdy")) AND (ATTDATE < date("03/03/2006","mdy")) THEN LET PQ="Y" ELSE LET PQ="N"
>
> Error Massages in Epi Analysis;
>  Data type mismatch
>
>
> IF ATTDATE date("01/01/2006","mdy") AND ATTDATE < date("03/30/2006","mdy") THEN LET PQ="Y" ELSE LET PQ="N"
>
> Error Massages in Epi Analysis;
>  Then is missing  
>  Script resulted in errors
>  Operation aborted 
>
> SET STATISTICS=OFF
> *End of PGM.
>
>
> I tried these command combinations one by one but bot no luck.
> The date ranges selection has been a tough challenge.
> The F1 help section also has no clue.
>
> Kindly help.
>
>
>
> Dr. Shavinder Singh
> Department of Community Medicine
>
>
>
>
>
>
>
>
> _______________________________________________
> EpiData-list mailing list
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>