And if you need to do additional processing on each observation (after the "filter") you can use a hiter (hash iterator) object.
%let keep=make model type origin msrp cylinders;
data limitfile1;
length tax 8.;
if _N_=1 then do;
if 0 then set sashelp.cars(keep=&keep);
declare hash H(
dataset:"sashelp.cars(keep=&keep where=(cylinders=6))");
H.definekey("make");
H.definedata("make","model","type","origin","msrp","cylinders");
H.definedone();
declare hiter I("H");
end;
rc=0;
do while(rc=0);
rc=I.next();
tax=msrp*.35;
output;
end;
stop;
run;
... View more
