DATA Step, Macro, Functions and more

Date Format Questions

Accepted Solution Solved
Reply
SAS Employee
Posts: 73
Accepted Solution

Date Format Questions

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


Accepted Solutions
Solution
‎08-05-2011 03:38 PM
PROC Star
Posts: 7,486

Re: Date Format Questions

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;

View solution in original post


All Replies
Solution
‎08-05-2011 03:38 PM
PROC Star
Posts: 7,486

Re: Date Format Questions

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;

SAS Employee
Posts: 73

Re: Date Format Questions

Thanks

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 163 views
  • 0 likes
  • 2 in conversation