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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1213 views
  • 2 likes
  • 3 in conversation