SAS numeric date to char

[jhusoc]

Hello,

I have a data like:

date = 20200124 the format is NUM 8 YYMMDDN8.

I am trying to convert the date's type as CHAR 8. as requested. 

I am using 

new_date = put(date yymmdddn8.)

;

It shows 21938 

Is that anyway can show the new_date as 20200124?

Thank you very much!

[Tom]

You missed a comma and you used an invalid format name.

new_date = put(date, yymmddn8.)

[jhusoc]

Sorry. I used comma in my code. However, the output is still 21938 NOT 20200124. Is there any way can show the output as 20200124? Thank you!

[PaigeMiller]

Works for me.

data have;
    date='24JAN2020'd;
    format date yymmddn8.;
run;
data want;
    set have;
    new_date=put(date,yymmddn8.);
run;

[jhusoc]

I think the reason is I did the calculation first, then the SAS give me the sysdate like: 21938. I formated the 21938 to 20200124. It may still 21938 in system. IS there a way can change from 21938 to 20200124 as char type? Thank you!

[jhusoc]

It should : 

new_date = put(date, yymmdddn8.);

[Reeza · Accepted solution]

Your format has too many d's. It needs two not three ds.

[jhusoc]

Thank you!