Date:         Tue, 2 Jan 2007 21:58:34 -0800
Reply-To:     lavanya <lavenskey@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         lavanya <lavenskey@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Macro code with proc report
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

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