topic SAS numeric date to char in SAS Programming

SAS numeric date to char

jhusoc — Thu, 05 May 2022 19:41:26 GMT

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!

Re: SAS numeric date to char

Tom — Thu, 05 May 2022 19:43:46 GMT

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

new_date = put(date, yymmddn8.)

Re: SAS numeric date to char

jhusoc — Thu, 05 May 2022 19:48:55 GMT

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!

Re: SAS numeric date to char

jhusoc — Thu, 05 May 2022 19:50:26 GMT

It should :

new_date = put(date, yymmdddn8.);

Re: SAS numeric date to char

PaigeMiller — Thu, 05 May 2022 19:51:49 GMT

Works for me.

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

Re: SAS numeric date to char

jhusoc — Thu, 05 May 2022 20:07:56 GMT

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!

Re: SAS numeric date to char

Reeza — Thu, 05 May 2022 20:46:33 GMT

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

Re: SAS numeric date to char

jhusoc — Thu, 05 May 2022 21:20:17 GMT

Thank you!