Sas date function

[chennupriya]

Hi ,

I have a variable in SAS which is character date 01JAN20:00:00:06 and format and informat are $123 and I wanted datepart of the date and I wanted it as 01JAN2020 .

Can anyone please help ?

[novinosrin · Accepted solution]

options YEARCUTOFF=1926;

data test;
char_date='01JAN20:00:00:06';
sas_date=input(char_date,date7.);
format sas_date date9.;
run;

Obs char_date sas_date

1 01JAN20:00:00:06 01JAN2020