BookmarkSubscribeRSS Feed
Bellefeuille
Obsidian | Level 7

I have a date, that is in text that looks like this

20170706

 

What i need to do is, convert it to a readable date and have it include in my where clause for filtering.

 

Similar to 

 

 

where create_dt >= date('2017-09-01')

 

 

Any help is appreciated.

2 REPLIES 2
ClarkLawson
Obsidian | Level 7

Using the following will create a SAS date variable which you can then use the filter

 

date=input('20170706',yymmdd8.)

 

I wouldn't then put that function into a DATASTEP where statement but you could do it on a sub setting IF statement.

Shmuel
Garnet | Level 18

Just to complete @ClarkLawson's answer:

 

The syntax to check date is:

  if date > '01SEP2017'd;

The format to use date as literel is 'ddmmmyyyy'd.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1494 views
  • 1 like
  • 3 in conversation