BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ak2
Calcite | Level 5 ak2
Calcite | Level 5

Hi.

I have a macro variable that is datetime. How can I remove the time stamp from the variable in a new let-statement?

 

I have this macro:

%let date0='22jan2018:0:0:0'dt;

 

I want to make a new macro like this:

%let date1=datepart(&date0.);

 

I have tried statements like this, but I can't get it to work:

%let date1=%sysfunc(datepart(&date0.))

 

Does anyone know how to convert &date0. into just a date-variable?

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

It does work!

%let date0='22jan2018:0:0:0'dt;
%let date1=%sysfunc(datepart(&date0.));

%put &date1.;

See the log:

24         %let date0='22jan2018:0:0:0'dt;
25         %let date1=%sysfunc(datepart(&date0.));
26         
27         %put &date1.;
21206

21206 is the raw numeric value for today's date, and can be used as-is in calculations and comparisons.

You only need to use a format for displaying the value.

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

It does work!

%let date0='22jan2018:0:0:0'dt;
%let date1=%sysfunc(datepart(&date0.));

%put &date1.;

See the log:

24         %let date0='22jan2018:0:0:0'dt;
25         %let date1=%sysfunc(datepart(&date0.));
26         
27         %put &date1.;
21206

21206 is the raw numeric value for today's date, and can be used as-is in calculations and comparisons.

You only need to use a format for displaying the value.

ak2
Calcite | Level 5 ak2
Calcite | Level 5
Thanks a lot!

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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