Hi all,

Can u help me in writing macro code with proc report....

%macro resp_report(resp_id =); proc report data = smmc._temp_chart3_b nowd headline headskip; COLUMN dim_id avg_self_rating avg_obs_rating avg_self_rating_ws avg_obs_rating_ws; DEFINE dim_id / display width =13 'Dimension ID'; DEFINE avg_self_rating / display 'Average Self Rating'; DEFINE avg_obs_rating / display 'Average Rating of Observer'; DEFINE avg_self_rating_ws / display 'Average Self Rating of the Workshop'; DEFINE avg_obs_rating_ws / display 'Average Observer Rating of the Workshop'; title "Report generation CHART3_B"; RUN; %mend resp_report; %resp_report(resp_id ='1')

I have written a code something like this, ... i dont know how to proceed from now in sense... how to run this macro for different resp_id, how do i call macro, in which statement should i use macro to execute this code..

Many thanks in advance Lavanya