Date comparisions

[sujain]

Hi,

I am new to SAS, the program below does not work, gives me this error:

ERROR: File WORK.ADMITDATE1.DATA does not exist.

I would really appreciate the help.
Thanks,
Sudhir

data frequency;
input AdmitDate1 date9.;
set AdmitDate(keep=AdmitDate1
where=(AdmitDate1 between '01Jan2003'd and
'30Jun2006'd));
format AdmitDate mmddyy10.;
datalines;
01Apr2002
01Apr2004
01Apr2005
01Apr2006
;
title "Frequency of Admissions";
proc print data=frequency ;
run;

 

[sasbuddy]

Are you sure you have the dataset called "AdmitDate" at your work library and Do you want to read the data from that Dataset?

If yes then please change the order of input and set statement.


sasbuddy

http://sites.google.com/site/sasbuddy/

 

[dearsamuna]

Hey buddy, do like this ok

data frequency(keep=admitdate1 where=(admitdate1 between between '01Jan2003'd and
'30Jun2006'd));
input admitdate1 date9.;
format AdmitDate mmddyy10.;
datalines;
01Apr2002
01Apr2004
01Apr2005
01Apr2006
;
title "Frequency of Admissions";
proc print data=frequency ;
run;
This sud work fine.Thanks