DATA Step, Macro, Functions and more

SAS Date Question

Reply
Occasional Contributor
Posts: 5

SAS Date Question

Hi, 

 

I have an existing data set with a list of dates (TX_DATE) formatted as MMDDYY10.

 

I want to tell SAS to only include dates after January 1, 2005.  

 

I tried doing this code, but it doesn't work. Any tips? 

 

data date;

set organ_transdate;

if TX_DATE >='01/01/2005'd;

run;

Super User
Posts: 17,960

Re: SAS Date Question

Date liberals are specified in a DATE9 format + letter d

 

'01Jan2005'd

 

 

Occasional Contributor
Posts: 5

Re: SAS Date Question

Thanks!!!! 

Ask a Question
Discussion stats
  • 2 replies
  • 130 views
  • 0 likes
  • 2 in conversation