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;
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;
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;
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!
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.
Ready to level-up your skills? Choose your own adventure.