I have a text file that has the following data
C
991699740
SOUTHWEST Data Example
088
9557427387
ROANOKE
A
546651740
NORTHWEST Data Example
065
6557427387
RICHMOND
Here is the code I use in SAS
data multi1;
infile 'v:\pcsas_export_files\Multi_Load\file_1.txt';
input Code $2. /
Acct $9. /
AcctName $30. //
ID $3. /
Reg $10. /
City $15.//
;
run;
In this example there are two entries, each beginning with a letter (in this case C and A). When I run the program the first record reads ok but not the second record. How can I get both records to read.
C
991699740
SOUTHWEST Data Example
088
9557427387
ROANOKE
A
546651740
NORTHWEST Data Example
065
6557427387
RICHMOND
Here is the code I use in SAS
data multi1;
infile 'v:\pcsas_export_files\Multi_Load\file_1.txt';
input Code $2. /
Acct $9. /
AcctName $30. //
ID $3. /
Reg $10. /
City $15.//
;
run;
In this example there are two entries, each beginning with a letter (in this case C and A). When I run the program the first record reads ok but not the second record. How can I get both records to read.