It's a little difficult to tell what you are asking for, but this might be a step in the right direction.
%macro subset (obsno);
data subset;
retain _obsno_ &obsno;
if _n_=1 then set have point=_obsno_;
set larger_dataset;
if variable_from_larger_dataset = name;
drop _obsno_ name;
run;
%mend subset;
%subset (5)
When calling the macro with OBSNO=5, the program gets the 5th observation where NAME is "sadf" and looks for all matching observations from your larger data set.
... View more
