data Base;
input id $ amount;
datalines;
a 189
b 160
b 188
b 165
a 145
a 199
b 198
b 345
c 298
c 165
d 235
d 678
e 161
e 285
f 278
;
data Name;
input id $ name $ n;
datalines;
a Jose 1
b Hose 2
c Jerry 3
d Sara 4
e Tom 5
;
data test6(drop=rc);
if 0 then set name;
if _n_ = 1 then do;
dcl hash h(dataset: 'name (where=(n < 3))');
h.definekey("id");
h.definedata("id","name",'n');
h.definedone();
end;
do until(eof);
set base end=eof;
name='';
rc=h.find();
output;
end;
run;



雷达卡


京公网安备 11010802022788号







