topic Re: Error Read in SAS Procedures

Error Read

Siddharth123 — Thu, 12 Sep 2013 18:23:13 GMT

Hi All,

Sometimes if the last variable is of shorther length than sepcified in length statement SAS doesnt read the value. For example, I have the datafile as:

Sid,Cricket,Basketball,LawnTennis

Tim,Basketball,Golf,Tennis

Phil,Football

If I use the code:

data test1;

length t x y z $10.;

infile 'C:\Documents and Settings\Datafile1.txt' dsd ;

input t x y z $10.;

proc print data = test1;

run;

The cursor whenever reads the last value less than length 10 moves to next line and incorrectly read the values. The output is:

Obs t x y z

1 Sid Cricket Basketball LawnTennis

2 Tim Basketball Golf Phil,Footb

Please sugest.

Regards

Re: Error Read

Reeza — Thu, 12 Sep 2013 18:32:24 GMT

Try the TRUNCOVER option on your input statement and read up on it

Re: Error Read

data_null__ — Thu, 12 Sep 2013 18:41:15 GMT

The problem is

input t x y z $10.;

$10. turns your LIST(DSD) input into FORMATTED which is incompatable with DSD.

Get rid of $10. since you don't actually need it because you used LENGTH statement to define it or add : modifier :$10. to use informat with list input.

Re: Error Read

data_null__ — Thu, 12 Sep 2013 18:41:54 GMT

TRUNCOVER is not correct for LIST input.

Reeza wrote:

Try the TRUNCOVER option on your input statement and read up on it

Re: Error Read

data_null__ — Fri, 13 Sep 2013 12:37:15 GMT

TRUNCOVER is not the correct solution to your problem!