Date:         Tue, 12 Nov 1996 10:27:00 EST
Reply-To:     Ming Lee <0007080955@MCIMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Ming Lee <0007080955@MCIMAIL.COM>
Subject:      Re: Help with macro and proc tabulate
Comments: To: Fernando Kvistgaard <FEK@lr.dk>

Hi Fernando,
 
If you want to have different titles as the macro execute, use a symput
statement in a _NULL_ datasets right before the PROC TABULATE within
the macro.
 
Example :
 
     %macro mac_tab(desc);
 
          data _null_;
 
             call symput('titlex','&desc');
 
          run;
 
          proc tabulate data=data1;
               class a b;
               table (a='Ha') all, b='Potatoes';
               title '&titlex';                <---- assigning title
               keylabel N='Group'
               all='Sum';
          run;
 
     %mend mac_tab;
 
%mac_tab(test);
 
Hope this helps.
 
Ming Lee
 
 
Date:     Tue Nov 12, 1996 09:16 am EST
Source-Date: Tue, 12 Nov 1996 09:08:37 GMT
From:     Fernando Kvistgaard
          EMS: INTERNET / MCI ID: 376-5414
          MBX: FEK@lr.dk
 
TO:       Multiple recipients of list SAS-L
          EMS: INTERNET / MCI ID: 376-5414
          MBX: SAS-L@uga.cc.uga.edu
BCC:    * Ming Lee / MCI ID: 708-0955
Subject:  Help with macro and proc tabulate
Message-Id: 81961112141618/0003765414DC3EM
Source-Msg-Id: <01bbd079$79b13f20$0a03010a@FEK.LR.DK>
U-Sender: "SAS(r) Discussion" <SAS-L@uga.cc.uga.edu>
U-From: Fernando Kvistgaard <FEK@lr.dk>
 
I have a global lets say NR
In proc tabulate how can I set TITLE = text string depending on NR value?
if &NR=10 then TITLE = 'Test'; --------------------   this doesn't work
 
My macro:
 
%macro mac_tab;
proc tabulate data=data1;
class a b;
table (a='Ha') all, b='Potatoes';
title '????????';
keylabel N='Group'
             all='Sum';
%mend mac_tab;
 
fek@LR.dk