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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.