Ying,

TRUNCOVER or MISSOVER might be used instead as well IMHO. Yet it seems your ascii file is damaged (read error from disk?) and should be fixed. At what position starts your data line in record 12907? Anyway set your LRECL to at least 136.

Regards - Jim. -- Y. Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070 senior statistician P.O. Box 1 fax. +31 412 407 080 5350 AA BERGHEM IMRO TRAMARKO: a CRO J.Groeneveld@ITGroups.com the Netherlands in clinical research

"My job is to keep my computer working." - Jim Groeneveld

> -----Original Message----- > From: HEATONE [SMTP:HEATONE@WESTAT.COM] > Sent: Wednesday, October 27, 1999 12:35 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: how to read large ascii file with missing data > > Ying, > Try the PAD option in your infile statement. It will add blanks to > your > short records so that SAS has something to read. > > > Edward Heaton, Sr. Systems Analyst, > Westat (An Employee-Owned Research Corporation), > 1550 Research Boulevard, Room 2018, Rockville, MD 20850-3159 > voice: (301) 610-4818 fax: (301) 294-3992 > mailto:heatone@westat.com http://www.westat.com > > > ____________________Reply Separator____________________ > Subject: how to read large ascii file with missing data > Author: yzhao@HAAS.BERKELEY.EDU > Date: 10/26/1999 11:27 PM > > Hi, > > I was trying to read a large ascii file (about 60000 observations) into > SAS. I used the options lrecl=104 and recfm=F in infile( because each > observation has 104 bytes). But after I ran it and got error messages, I > found that observations 12601-12905 of the data has missing values. So I > read the whole data set in two steps, first I read observations from 1 > to 12600, then I read obs from 12906 till the end. But I had some > problems with the second step. The data in line 12906 begins in column > 33, so I use the same option lrecl=104 and recfm=F , and in the input I > wrote : > var1 33-34 > var2 35-39 > .. > var30 134-136 > > but in the output file I found that in each observation the data value > for var17-var30 (which has 32 bytes in total) are not what they are > supposed to be, seems that the program read these dada from other line > insead of the place I wanted it to be. Couold any one tell me what might > be the problem and how I can fix it? Thank you! have a nice day! > > Ying Zhao > > > Sent via Deja.com http://www.deja.com/ > Before you buy.