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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.