txt to SAS dataset

[Smitha9]

Hi,

I have a txt file which looks like

ID SNO         start               stop           Lon       Len       Tod           date

1      2     09/02/2003   12/06/2020     10004   10006    10007   20040809  

the start and stop are in mm/dd/yyyy format

date is yyyymmdd format.

I want all the txt to convert to SAS dataset.

And the date must be formatted to mm/dd/yyyy

can I do this in SAS?

[PeterClemmensen]

Google is your friend. Use the data step and the Infile Statement 🙂

[Kurt_Bremser]

data want;
input ID $ SNO $ start :mmddyy10. stop :mmddyy10. Lon Len Tod date :yymmdd8.;
format start stop date mmddyy10.;
datalines;
1      2     09/02/2003   12/06/2020     10004   10006    10007   20040809  
;