I have a situation where I need to convert a date to date9. in a macro variable
%let date=2012-01-01;
I need to convert above date to date9. format in to another macro variable.
ANy help is much appreciated.
Use %sysfunc and inputN function to convert:
%let date=2012-01-01;
%let date_d9=%sysfunc(inputn(&date, yymmdd10.), date9.);
%put &date_d9.;
Use %sysfunc and inputN function to convert:
%let date=2012-01-01;
%let date_d9=%sysfunc(inputn(&date, yymmdd10.), date9.);
%put &date_d9.;
Thank you for this solution Reeza. It really helped me today! 🙂
Hi all,
I tried the same thing but it does not work here:
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?
If you have a new question open a new thread. You can add a link back to the old thread to provide context if you want.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.