Hi Tim, Try
SELECT NOT variable = (.)
Have a nice day!
Also you could try an
IF NOT variable=(.)
Thank you for the replies, I knew it would be a simple fix.
I do have another problem I need to address.
I need to be able to run a frequency report that checks dates entered fall within a compliant date or not. I have two variables (date vaccine was given or declined) that need to be checked to see if the date is within the last year or not. The dates will not be replaced, we will be adding a new record to that patient. I need to be able to have it check only the last record entered.
Here is one attempt. The IF command does not work.
IF VACCINATIONDATE= (YEARS(FLUVACDATE, SYSTEMDATE) >=1) AND VACCINATIONDECLINED= (YEARS(FLUVACDECLINED, SYSTEMDATE) >=1) THEN
FREQ COMPLIANCE MISSING=(+)
Here is another one that I have tried:
ASSIGN VACCINATIONDATE= YEARS(VACDATE,SYSTEMDATE)
ASSIGN VACCINEDECLINED= YEARS(VACDECLINED, SYSTEMDATE)
IF VACCINATIONDATE >=1 AND VACCINEDECLINED >=1 THEN
Attached is an example EpiInfo 3.5 mdb database and Analysis pgm file that shows what you may be looking for. Copy the files to c:\temp and run the pgm file in Analysis. The criteria for "Compliant" can be easily changed depending on your definition.
Hope this helps,