BookmarkSubscribeRSS Feed
srinidhi
Fluorite | Level 6

Hi,

 

Could Please help how to read or import in SAS, if a dataset like below.

The input file can only have a max of 8 values in single row and this data set has 10 variables.

 

 

ABCDEFGH

IJABCDEF

GHIJABCD

EFGHIJ

 

Output:

 

A,B,C,D,E,F,G,H,I,J 

A,B,C,D,E,F,G,H,I,J

A,B,C,D,E,F,G,H,I,J

 

 

Thanks,

Srinidhi

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Not easily.  Its more about understanding the data.  For instance:

345678910

You could assume the last two digits are the final number, but:

345678190

Would the last two still be the last number?  Or should it be zero and the previous one be 19?

Why is the data like that?  A demilited file will make your life a lot easier.  

 

Also note that your want dataset data does not match you have data, row one does not contain a 9 for instance, and there are four rows in the have and only 3 in the want.  Perhaps provide some acurate test data and describe what you want in more detail, i.e. the how and why.

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
  • 1 reply
  • 1020 views
  • 1 like
  • 2 in conversation