topic Re: Need Help Reading Column into Date Format in SAS Programming

Need Help Reading Column into Date Format

danielhanbitlee — Thu, 22 Mar 2018 06:30:40 GMT

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
;

Re: Need Help Reading Column into Date Format

Astounding — Thu, 22 Mar 2018 07:00:40 GMT

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.

Re: Need Help Reading Column into Date Format

danielhanbitlee — Thu, 22 Mar 2018 19:35:01 GMT

Awesome! Thank you!