BookmarkSubscribeRSS Feed
manoj_pandey
Fluorite | Level 6

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.

 

3 REPLIES 3
manoj_pandey
Fluorite | Level 6

It's worked. Thank you

ShiroAmada
Lapis Lazuli | Level 10

Try this

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1186 views
  • 2 likes
  • 3 in conversation