topic Re: What is DATES3M9. date format? How do I convert it to DATE9. format? in New SAS User

What is DATES3M9. date format? How do I convert it to DATE9. format?

Sujithpeta — Mon, 04 Mar 2019 14:42:30 GMT

Hey, I've a column "DeathDate" in my dataset which is supposed to be a date variable, but the data format and type are numerical, the format is also shown as DATES3M9.

I didn't get any search result on this date format on google. Wondering if it's possible to convert this to DATE9. Or column is made such that to de-identify. Below is how the data points look in the data.

Thanks

DeathDate
18494
19078
19142
19147
19196
19247
19366
19443
19487
19426
19848
19908
20086
20230
20352

Re: What is DATES3M9. date format? How do I convert it to DATE9. format?

novinosrin — Mon, 04 Mar 2019 14:44:46 GMT

If they are just numbers, you could apply any format you want


data dd;
input dd;
format dd date9.;
cards;
18494
19078
19142
19147
19196
19247
19366
19443
19487
19426
19848
19908
20086
20230
20352
;

Re: What is DATES3M9. date format? How do I convert it to DATE9. format?

Sujithpeta — Mon, 04 Mar 2019 14:50:52 GMT

Thanks Brother