Date Format Questions

[newbi]

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 · Accepted solution]

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]

Thanks