Convert SAS date9 to character yyyymmdd

Reply
Occasional Contributor
Posts: 13

Convert SAS date9 to character yyyymmdd

Hi Guys,

How does one convert SAS date9 to character yyyymmdd:

2013DEC02 to 20131202

Thanks

Respected Advisor
Posts: 3,837

Re: Convert SAS date9 to character yyyymmdd

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

Ask a Question
Discussion stats
  • 1 reply
  • 4624 views
  • 0 likes
  • 2 in conversation