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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.