BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sujithpeta
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

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
;

 

 

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20

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
;

 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 534 views
  • 0 likes
  • 2 in conversation