topic Re: Data Reading Eror in Administration and Deployment

Data Reading Eror

pallis — Tue, 17 Sep 2013 13:05:03 GMT

HI All,

I have an issue when reading data

This is my data file

Name,sal,comm

venkat srini,1000 ,300

srinivas,kiran,raju,3000,150

When I import into sas the data is reading as

Name sal comm

venkat srini 1000 300

srinivas kiran raju

Can you let me know solution. My data is 28gb. can any one let me know solution for this issue.

regards,

venky

Re: Data Reading Eror

LinusH — Tue, 17 Sep 2013 13:21:32 GMT

It's a large file for not having a proper lay-out...

In row 2, does it mean three persons, or just one person with three names?

If possible, get back to your supplier and have the generate file with a better structure.

Re: Data Reading Eror

pallis — Tue, 17 Sep 2013 13:22:17 GMT

Its one person with 3 names

Re: Data Reading Eror

Oleg_L — Tue, 17 Sep 2013 13:25:24 GMT

This may be useful.

https://communities.sas.com/thread/13128?start=0&tstart=0

Oleg.

Re: Data Reading Eror

Oleg_L — Tue, 17 Sep 2013 14:11:10 GMT

length dlm $1;

dlm = ',';

infile cards dsd dlm=dlm;

informat name $30. sal 8. comm 8.;

input @;

call scan(_infile_,-2,end,_n_,',');

length = end-1-1;

input name $varying30. length +1 sal comm;

keep name sal comm;

cards;

venkat srini,1000 ,300

srinivas,kiran,raju,3000,150

;

Re: Data Reading Eror

pallis — Wed, 18 Sep 2013 07:19:11 GMT

Thanks for the work. Can you explain me the steps I unable to figure out.

Re: Data Reading Eror

Oleg_L — Wed, 18 Sep 2013 08:25:44 GMT

length = end-1-1; -> the length of the string that we are reading into variable name.

Hope this helps.

Oleg.

Re: Data Reading Eror

LinusH — Wed, 18 Sep 2013 08:35:34 GMT

Neat solution.

But if the real data is more complex (have more columns), it could require some extensive programming.

So from an architectural perspective, it would still be better to require a different file lay-out (fixed width, or char columns enclosed by <">).

Re: Data Reading Eror

Oleg_L — Wed, 18 Sep 2013 08:51:20 GMT

I take this solution from the post of DN (Data _null_). See the link above.