You could consider a hash object to eliminate duplicates in a data step.
%let keep=make model type origin msrp cylinders;
data robm.limitfile1;
if _N_=1 then do;
if 0 then set sashelp.cars(keep=&keep);
declare hash H(
dataset:"sashelp.cars(keep=&keep where=(cylinders=6))",
ordered:"ascending");
H.definekey("make");
H.definedata("make","model","type","origin","msrp","cylinders");
H.definedone();
H.output(dataset:"work.limit");
end;
run;
The hash object rejects duplicate keys by default. Leave off the ordered parameter if order does not matter in the result.
... View more
