Error Read

[Siddharth123]

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

SK

[Reeza · Accepted solution]

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

[data_null__]

TRUNCOVER is not correct for LIST input.

Reeza wrote:

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

[data_null__]

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.

[data_null__]

TRUNCOVER is not the correct solution to your problem!