character YYMMDD10 to DATE9

[SASAna]

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 · Accepted solution]

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]

Thank you. worked very well .

[Kurt_Bremser]

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.