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

Hi. I have the following cards statement, but I can't figure out how to read in the date column (CL_FROM_DT) as a SAS date instead of a character string.  I'd appreciate the help.  Thanks.

 

DATA HAVE;
LENGTH ID_NUM $ 10 ENRLMT_NUM $ 9 CL_FROM_DT $ 9;
INPUT ID_NUM $ B_ID $ ENRLMT_NUM $ CL_FROM_DT $ H_CD $;
DATALINES;
1174620710 1169339 030490008 30JAN2018 L0180
1174620710 1169339 030490008 30JAN2018 L3960
1285980003 1169339 454072764 30DEC2017 L0650
1477921666 1169339 472633814 23JAN2018 L1851
1477921666 1169339 472633814 23JAN2018 L2397
1851421663 1169339 561727024 22DEC2016 L0627
1851421663 1169339 561727024 01MAY2018 L0976
1851421663 1169339 561727024 01MAY2018 L1030
1851421663 1169339 561727024 01MAY2018 L1040
1851421663 1169339 561727024 01MAY2018 L1050
1851421663 1169339 561727024 01MAY2018 L2397
1851421663 1169339 561727024 01MAY2018 L2810
1366995144 2318543 813131377 08DEC2017 L0650
1366995144 2318543 813131377 08DEC2017 L3916
1417255761 2318543 274931342 20NOV2017 L0650
1972863868 2318543 455151476 14NOV2017 L0650
;RUN;

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
DATA HAVE;
LENGTH ID_NUM $ 10 ENRLMT_NUM $ 9;
INPUT ID_NUM $ B_ID $ ENRLMT_NUM $ CL_FROM_DT :date9. H_CD $;
format CL_FROM_DT date9. ;
DATALINES;
1174620710 1169339 030490008 30JAN2018 L0180
1174620710 1169339 030490008 30JAN2018 L3960
1285980003 1169339 454072764 30DEC2017 L0650
1477921666 1169339 472633814 23JAN2018 L1851
1477921666 1169339 472633814 23JAN2018 L2397
1851421663 1169339 561727024 22DEC2016 L0627
1851421663 1169339 561727024 01MAY2018 L0976
1851421663 1169339 561727024 01MAY2018 L1030
1851421663 1169339 561727024 01MAY2018 L1040
1851421663 1169339 561727024 01MAY2018 L1050
1851421663 1169339 561727024 01MAY2018 L2397
1851421663 1169339 561727024 01MAY2018 L2810
1366995144 2318543 813131377 08DEC2017 L0650
1366995144 2318543 813131377 08DEC2017 L3916
1417255761 2318543 274931342 20NOV2017 L0650
1972863868 2318543 455151476 14NOV2017 L0650
;RUN;

 

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20
DATA HAVE;
LENGTH ID_NUM $ 10 ENRLMT_NUM $ 9;
INPUT ID_NUM $ B_ID $ ENRLMT_NUM $ CL_FROM_DT :date9. H_CD $;
format CL_FROM_DT date9. ;
DATALINES;
1174620710 1169339 030490008 30JAN2018 L0180
1174620710 1169339 030490008 30JAN2018 L3960
1285980003 1169339 454072764 30DEC2017 L0650
1477921666 1169339 472633814 23JAN2018 L1851
1477921666 1169339 472633814 23JAN2018 L2397
1851421663 1169339 561727024 22DEC2016 L0627
1851421663 1169339 561727024 01MAY2018 L0976
1851421663 1169339 561727024 01MAY2018 L1030
1851421663 1169339 561727024 01MAY2018 L1040
1851421663 1169339 561727024 01MAY2018 L1050
1851421663 1169339 561727024 01MAY2018 L2397
1851421663 1169339 561727024 01MAY2018 L2810
1366995144 2318543 813131377 08DEC2017 L0650
1366995144 2318543 813131377 08DEC2017 L3916
1417255761 2318543 274931342 20NOV2017 L0650
1972863868 2318543 455151476 14NOV2017 L0650
;RUN;

 
buechler66
Barite | Level 11
Thanks for the help. I appreciate your time!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 995 views
  • 3 likes
  • 2 in conversation