Convert SAS date9 to character yyyymmdd

Avenue — Tue, 29 Jul 2014 11:38:05 GMT

Hi Guys,

How does one convert SAS date9 to character yyyymmdd:

2013DEC02 to 20131202

Thanks

Re: Convert SAS date9 to character yyyymmdd

Patrick — Tue, 29 Jul 2014 12:01:46 GMT

"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;

topic Re: Convert SAS date9 to character yyyymmdd in SAS Programming

Convert SAS date9 to character yyyymmdd

Re: Convert SAS date9 to character yyyymmdd