Field Name Start Column End Column Data Type
Type 1 1 character
ID 3 6 character
Name 8 22 character
Date 3 10 numeric
Amount 12 17 numeric
Raw Data File Jan98dat
1---+----10---+----20--
P 1095 SMITH, HOWARD
C 01-08-98 $45.0
C 01-17-98 $37.5
P 1096 BARCLAY, NICK
C 01-09-98 $156.5
正确答案是:
data sasuser.billing1 (drop=type);
infile jan98dat;
retain ID Name;
input type $1. @;
if type='P' then input @3 id $4. @8 name $15.;
[b:30uoj7vo]if type='C';[/b:30uoj7vo]
input @3 Date mmddyy8. @12 Amount comma6.;
format date mmddyy8. amount dollar7.2;
run;
proc print data=sasuser.billing1;
run;