Hi Guys,
How does one convert SAS date9 to character yyyymmdd:
2013DEC02 to 20131202
Thanks
"2013DEC02" is not a string in date9 format.
Are you dealing with a SAS date value (=numeric variable containing a number representing the number of days since 1 january 1960) or are you dealing with a string?
Should the result be a string or is this simply about applying a date format to a SAS date value?
Below code gives you examples for both cases.
data demo;
DT_String_In='2013DEC02';
SAS_DT_Value_no_date_format=input(DT_String_In,anydtdte.);
format SAS_DT_Value_with_date_format yymmddn.;
SAS_DT_Value_with_date_format=input(DT_String_In,anydtdte.);
DT_String_Out=put(SAS_DT_Value_no_date_format,yymmddn.);
output;
DT_String_Out=put(SAS_DT_Value_with_date_format,yymmddn.);
output;
run;
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.