topic Re: Importing Data in SAS Programming

Importing Data

srinidhi — Tue, 20 Feb 2018 10:20:52 GMT

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

Thanks,

Srinidhi

Re: Importing Data

RW9 — Tue, 20 Feb 2018 09:01:15 GMT

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.