topic Re: Convert numeric to date format in SAS Programming

Convert numeric to date format

Rixile106 — Tue, 29 Aug 2023 12:18:21 GMT

DATA want;
SET have ;

	FORMAT Open_Dt DATE9.;
 Open_Dt= PUT (TAKE_UP_DATE_CD,YYMMDD10.) ;
RENAME DIFF =DIFF_AMT ;

RUN

can you please assist in converting this a numberic value to date format

expected outcome

Astounding — Tue, 29 Aug 2023 12:37:55 GMT

What is the name of the variable that you wish to convert?

Give a few examples of the values that it currently has.

Rixile106 — Tue, 29 Aug 2023 12:47:18 GMT

it is a numeric value

Astounding — Tue, 29 Aug 2023 12:51:23 GMT

You get no information until you actually answer my questions.

Rixile106 — Tue, 29 Aug 2023 12:58:48 GMT

PaigeMiller — Tue, 29 Aug 2023 13:05:48 GMT

Numbers like this look like dates to human, but are not dates to SAS. The conversion is

newdate=input(put(date,8.),yymmdd8.);
format new_date date9.;

Astounding — Tue, 29 Aug 2023 13:14:45 GMT

You answered one question, but not the other. Without knowing the variable name you are talking about, we have to guess which variable you mean.

@PaigeMiller took a good guess. I suggest you try his solution. But be consistent in your choice of names for the new variable: new_date vs. newdate.