DATA Step, Macro, Functions and more

Sas Date question

Reply
Occasional Contributor
Posts: 18

Sas Date question

To check a sas date in an if condition I always go to a bookmarked site to look up the sas date.

Is there a way to use the actual date in a date varible?

For example instead of
If StartDate = 58251

I would like to say
If StartDate = 201801

Is there a way to do that9

Thank you for your help
Super User
Posts: 4,023

Re: Sas Date question

If StartDate = '01Jan2018'd

The "D" tells SAS to treat the string constant as a date.

Occasional Contributor
Posts: 18

Re: Sas Date question

Thank you very much! I will give that a try Smiley Happy
Occasional Contributor
Posts: 18

Sas Date question

[ Edited ]

Double post deleted.

Occasional Contributor
Posts: 18

Re: Sas Date question

 
Super User
Posts: 6,933

Re: Sas Date question

You can refer to a specific day without knowing the numeric value on SAS's date scale.  For example:

 

if datevar = '04Apr2018'd then do;

 

The date must be in quotes, must be in the format illustrated here, and must add a "d" after the closing quote.

Ask a Question
Discussion stats
  • 5 replies
  • 155 views
  • 0 likes
  • 3 in conversation