This is Learn_uk with a changed username: We finally got SAS 9.4 on our computers and I am now going to present the solution to what I was hoping for...Thanks to Gergely for his advice: data x; input pt wt; datalines; 1001 120 1002 244 1002 246 1003 145 1004 241 ; data y; input pt; datalines; 1002 1003 1005 ; %let result=.; %macro search(id); proc sql noprint; select mean(wt) into :result from x where pt=&id; quit; %mend search; data y2 (drop=rc); set y; rc=dosubl('%search(id='||pt||')'); wt=symget('result'); run;
... View more