Can someone help me read the DATE variable as a DATE7. format? I failed so I am just reading it as character format. The code is below. I am using SAS University Edition. Thanks.
data sasuser.amounts;
input Name $1-12 EmpID 14-18 Date $20-26 Amt 28-29;
datalines;
ANKERTON, L. 11123 08OCT16 92
ANKERTON, L. 11123 15OCT16 43
DAVIS, R. 22298 04OCT16 16
MASTERS, T. 33351 13OCT16 18
MASTERS, T. 33351 27
THOMAS, A. 21OCT16 15
WOLMER, B. 44483
;
Assuming that the date always appears in columns 20-26:
input ..... @20 date date7. ...........;
You would probably want to add a FORMAT statement to print DATE in the format of your choice when displaying the data.
Assuming that the date always appears in columns 20-26:
input ..... @20 date date7. ...........;
You would probably want to add a FORMAT statement to print DATE in the format of your choice when displaying the data.
Awesome! Thank you!
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!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: