topic Re: character YYMMDD10 to DATE9 in SAS Programming

character YYMMDD10 to DATE9

SASAna — Tue, 21 Apr 2020 15:57:04 GMT

Hi SAS users,

Need help with converting this character date to DATE9 like below.

date1 is the input format data is coming in. Date_out should be '01APR2019'd

data test;
date1 = '2019-04-01' ;
date2 = dequote(date1);
call symputx("date2" , "'"|| input(put(dequote(date1), yymmdd10.),date9.) ||"'d",'g');
run;

%put &date2;

Thanks,

Ana

Jagadishkatam — Tue, 21 Apr 2020 16:05:27 GMT

please try the below code

data test;
date1 = '2019-04-01' ;
call symputx("date2" , cats("'",put(input(date1,yymmdd10.),date9.),"'d"));
run;

 

%put &date2;

SASAna — Tue, 21 Apr 2020 16:11:48 GMT

Thank you. worked very well .

Kurt_Bremser — Tue, 21 Apr 2020 18:00:45 GMT

Since you need a date literal for use in code, no format us needed:

data test;
date1 = '2019-04-01';
call symputx("date2",input(date1,yymmdd10.),'g');
run;

%put &date2;

See Maxim 28.