Looks like some process has inserted random line breaks at around 256 characters. Probably some type of misguided download process or strange file specification on the program that made the file.
But it looks like you can FIX the file to have one line per observation by just counting the number of tabs that you have read so far.
FILENAME rawinput "c:\downloads\test.txt" ;
filename fixed temp;
data _null_;
infile rawinput termstr=crlf end=eof;
file fixed termstr=crlf ;
do until(eof or ntabs > 60);
input ;
put _infile_ @ ;
ntabs = sum(ntabs,countc(_infile_,'09'x));
end;
put;
putlog _n_= ntabs=;
run;
Now you can read the new file using normal code. For example here is your program fixed up.
- Uses DSD option on INFILE statement to properly parse when there are missing values.
- Removes the old style MISSOVER option (which was being overridden by the TRUNCOVER option that followed it anyway).
- Uses LENGTH to define the variables instead of attaching unneeded informats. That way SAS does not have to guess that it how it should define the variables by assuming that the width of the informat that has been attached should match the length of the variable to be created.
- Simplifies the INPUT statement since the variables have already been defined in the order they appear in the file.
data new;
infile fixed dsd dlm='09'x firstobs=2 termstr=crlf truncover ;
length
DOD_YR $4
DSTATE $2
FILENO $6
GNAME $50
MNAME $1
LNAME $50
SEX $1
SSN $9
AGETYPE $1
AGE $3
DOB_YR $4
DOB_MO $2
DOB_DY $2
BPLACE_CNT $2
BPLACE_ST $2
STATEC $2
MARITAL $1
DPLACE $1
DOD_MO $2
DOD_DY $2
DEDUC $1
OCCUP $40
OCCUPC $3
INDUST $40
INDUSTC $3
ACME_UC $5
AUTOP $1
CERTL $30
DINSTI $30
STNUM_R $10
STNAME_R $50
STDESIG_R $10
POSTDIR_R $10
UNITNUM_R $7
CITYTEXT_R $28
ZIP9_R $9
STATETEXT_R $28
ADDRESS_R $50
DETHNICE $3
NCHSBRIDGE $2
HISPOLDC $1
RACEOLDC $1
DMIDDLE $50
COD1A $120
INTERVAL1A $20
COD1B $120
INTERVAL1B $20
COD1C $120
INTERVAL1C $20
COD1D $120
INTERVAL1D $20
OTHERCONDITION $240
CERTFIRST $50
CERTMIDDLE $50
CERTLAST $50
MEC_YR $4
MEC_MO $2
MEC_DAY $2
MEC_NUMBER $8
AGE_CALC $3
MAR_WARD $6
MAR_CENSUS_TRACT $9
;
input DOD_YR -- MAR_CENSUS_TRACT ;
run;
NOTE: 3 records were read from the infile FIXED.
The minimum record length was 313.
The maximum record length was 381.
NOTE: The data set WORK.NEW has 3 observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds
