Convert SAS date

MILKYLOVE — Wed, 04 Oct 2023 08:36:24 GMT

Hello

For some reasons I can't seem to do this. How do I convert a date

DATE = '20231002' to

DATE_EXTRACTION = '02OCT2023' in SAS please?

I have tried :

DATE_EXTRACTION = put(datepart(DATE), date9.);

But I get 22AUG1960 instead of 02OCT2023

Re: Convert SAS date

PeterClemmensen — Wed, 04 Oct 2023 09:03:52 GMT

Try this

data test;
   date = '20231002';
   new  = put(input(date, yymmdd8.), date9.);
run;

Re: Convert SAS date

PaigeMiller — Wed, 04 Oct 2023 10:17:33 GMT

@MILKYLOVE wrote:

Hello

For some reasons I can't seem to do this. How do I convert a date

DATE = '20231002' to

DATE_EXTRACTION = '02OCT2023' in SAS please?

I have tried :
DATE_EXTRACTION = put(datepart(DATE), date9.);
But I get 22AUG1960 instead of 02OCT2023

Dates should never be character strings, they should be numbers. Numbers that represent the number of days since 01JAN1960.

Had you written this

DATE = '02OCT2023'd;
format date date9.;

you would have the correct date ... this is the way to translate dates that you understand to numerical SAS dates. Also please note that this will not work:

DATE = '20231002'd;

Lastly, when you have actual SAS dates, you do NOT need the DATEPART function; the only time you need the DATEPART function is when the value is SAS date/time values. But your value is a SAS date, not a date/time value, and DATEPART will not do meaningful things to date values.

topic Convert SAS date in SAS Programming

Convert SAS date

Re: Convert SAS date

Re: Convert SAS date