topic Re: txt to SAS dataset in New SAS User

txt to SAS dataset

Smitha9 — Wed, 13 Jan 2021 14:05:54 GMT

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?

Re: txt to SAS dataset

PeterClemmensen — Wed, 13 Jan 2021 14:13:54 GMT

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

Re: txt to SAS dataset

Kurt_Bremser — Wed, 13 Jan 2021 14:16:23 GMT

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  
;