running a macro with each observation in sas

Question

I've got a macro which draws a pie chart for a provided ID. It basically chooses a row from a table, then transposes obtained one-row table and then draws a pie chart. It works perfectly fine if I call it for one observation (for ex. %StudPieChart(931123)). Here's the code:

%MACRO StudPieChart(id);
data projekt.temp;
set projekt.cwiczenia(keep=nrInd KOL1 KOL2 KOL3 aktywnosc where= (nrInd=&id));
drop nrInd;
run;

proc transpose data=projekt.temp out=projekt.temp;
run;

proc gchart data=projekt.temp;
    pie _NAME_ / sumvar=COL1 percent=inside;
run;
%MEND;

Now I want draw a chart for not one, but some sample of observations. So I generated random sample and tried to run a macro in a data step. But it doesn't work anymore and I have no clue why.

Here's the rest of code:

proc surveyselect data=projekt.cwiczenia out=projekt.sample(keep=nrInd) sampsize=5 NOPRINT;
run;


data _NULL_;
set projekt.sample;
%StudPieChart(nrInd);
run;

Answer 1

You can use CALL EXECUTE.

data _NULL_;
   set projekt.sample;
   call execute('%nrstr(%StudPieChart('||nrInd||'));');
   run;

RTM: http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p1blnvlvciwgs9n0zcilud6d6ei9.htm