06-20-2016 08:21 AM
I'm using a date format: FORMAT DATE MONYY5.
the data appears correctly in the dataset, but whenever I try to subset on that date, I receive an error:
36 PROC SGPLOT DATA = TOT_CLABSI (WHERE=(DATE < "APR16"d ));
ERROR: Invalid date/time/datetime constant "APR16"d.
Please help me figure out what I'm doing wrong1
06-20-2016 08:23 AM
A SAS date constant must always include days, months and years.
Therefore you need to enter it as '01apr2016'd in this case.
06-20-2016 08:24 AM
PS no matter how it is formatted, a SAS date is always a number, counting days from January 1st, 1960.