topic Re: subsetting in a where clause with a date format in SAS Programming

subsetting in a where clause with a date format

tmtemples — Mon, 20 Jun 2016 12:21:05 GMT

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

Thank you!

Kurt_Bremser — Mon, 20 Jun 2016 12:23:12 GMT

A SAS date constant must always include days, months and years.

Therefore you need to enter it as '01apr2016'd in this case.

Kurt_Bremser — Mon, 20 Jun 2016 12:24:23 GMT

PS no matter how it is formatted, a SAS date is always a number, counting days from January 1st, 1960.

tmtemples — Mon, 20 Jun 2016 12:28:28 GMT

Thank you! I though I needed to use the same format!

riyaaora275 — Mon, 21 May 2018 19:09:05 GMT

Can you explain why we cannot use MONYY5. informat?

Eg: where ( date = "JAN95"MONYY5.)

I am not able to understand why we cannot write this