DATA Step, Macro, Functions and more

Convert macro variable to different date format

Accepted Solution Solved
Reply
Contributor
Posts: 53
Accepted Solution

Convert macro variable to different date format

Hi all,

 

I tried to convert a sas date in a macro variable into a different format like in https://communities.sas.com/t5/Base-SAS-Programming/Macro-to-convert-character-to-numeric-variable/m..., but it does not work for me:

 

23         %put &StT; /* aus der Eingabeaufforderung */
20170401
24          
25         %let dateend = %sysfunc(putn(%sysfunc(INPUTN(%sysfunc(PUTN(&StT, Z8.)), YYMMDD8.)), date9.));
26         %put &dateend;
01APR2017
27          
28          
29         %PUT SAS DATA VALUE: &StT;
SAS DATA VALUE: 20170401
30          
31         %let dateend2 = %sysfunc(INPUTN(&StT, Z8.), date9.);
32         %put &dateend2;
*********
33        

 

I cannot find my error. Can somebody please help?


Accepted Solutions
Solution
‎06-27-2017 10:35 AM
Super User
Posts: 7,866

Re: Convert macro variable to different date format

Use a correct date informat in the inputn function:

%let dateend2 = %sysfunc(INPUTN(&StT, YYMMDD8.), date9.);

just as you did in the first %let.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎06-27-2017 10:35 AM
Super User
Posts: 7,866

Re: Convert macro variable to different date format

Use a correct date informat in the inputn function:

%let dateend2 = %sysfunc(INPUTN(&StT, YYMMDD8.), date9.);

just as you did in the first %let.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 1,586

Re: Convert macro variable to different date format

on line 31 you missed the PUTN function:

 

%let dateend2 = %sysfunc(INPUTN(PUTN(&StT, Z8.), YYMMDD8.), date9.);

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 906 views
  • 2 likes
  • 3 in conversation