topic Date Format Questions in SAS Programming

Date Format Questions

newbi — Fri, 05 Aug 2011 18:53:35 GMT

I need to select everything from table A where the data is from previous day.

Table A has "Date_Key" which is numeric

Example: 20110805

How can i subtract 20110805 - 1 in Proc SQL to get 20110804 data ?

Thanks

art297 — Fri, 05 Aug 2011 19:37:59 GMT

Depends upon whether that numeric field contains a SAS date that is only appearing in that format, or the number 20,100,805

If it is already a SAS date, then you would only need Date_Key-1

If it really is the number 20,100,805 you could use something like:

data have;

input Date_Key;

cards;

20110804

;

proc sql;

select *

from have

having input(put(Date_Key,z8.),yymmdd8.)=today()-1

;

quit;

newbi — Fri, 05 Aug 2011 20:41:15 GMT

Thanks