topic Re: convert numeric into date in New SAS User

convert numeric into date

aanan1417 — Thu, 04 Aug 2022 09:26:14 GMT

data a;

input dtevisit;

datalines;

22120715

;

run;

output

24apr2022

Re: convert numeric into date

PeterClemmensen — Thu, 04 Aug 2022 09:38:47 GMT

How does 22120715 become 24apr2022 ?

Re: convert numeric into date

PaigeMiller — Thu, 04 Aug 2022 10:07:46 GMT

Marking an answer correct that is not an answer — but is actually a question from @PeterClemmensen — helps no one. Answering the question would be helpful.

Re: convert numeric into date

ballardw — Thu, 04 Aug 2022 14:07:25 GMT

What file type did you get that value from?

IF this is direct transfer from some other data system then that data likely uses a different base day number to date than SAS uses (01JAN1960).

Since you do not have a 24 in that random number then it appears that none of the digits correspond to day of month, month and the 22 may just be coincidence as a possible year value. (2-digit years are bad idea in general).