topic Reading raw data from an external files in SAS Programming

Reading raw data from an external files

manoj_pandey — Tue, 11 Dec 2018 06:15:27 GMT

I have data in .txt file ,where each word is separated by single space like below.

mayoflstat mayolc accrual mayolc

Now I would like to read the .txt file and create a single variable having the below values.

Text

mayoflstat

mayolc

accrual

mayolc

data test;
INFILE '/home/rpv/var.txt' dlm =" " ;
INPUT Text $1000.;
RUN;

I there any options need to add the above code to get the required result? or need to update the code.

Thank you in advance.

learsaas — Tue, 11 Dec 2018 06:55:18 GMT

ShiroAmada — Tue, 11 Dec 2018 06:56:04 GMT

Try this

data test;
  infile "<your path here>" truncover;
  input var $30. @;
  run;

manoj_pandey — Tue, 11 Dec 2018 07:00:00 GMT

It's worked. Thank you