Data visualization with SAS programming

Proc Template with MACRO

Reply
Frequent Contributor
Posts: 78

Proc Template with MACRO

Hi All,

 

Is that possible to use proc template in macro?

I use a proc templat in SAS to combine 6 figures in to one page, that's good. But I have lots of variables, which means I have to run this proc template many times, but I don't want to change every variable name after I run out proc template once.  Someone can give me an  example to run proc template but use macro? I google, but didn't find a good example.

 

Thanks,

C

Super User
Super User
Posts: 6,843

Re: Proc Template with MACRO

I would think that the point of using PROC TEMPLATE would be to eliminate the need for MACRO coding.

What type of template are you creating?

What is it that is varying?

SAS Super FREQ
Posts: 8,819

Re: Proc Template with MACRO

Hi:
The SAS Macro facility only generates code. So I do not understand your question about using proc template "in macro". Do you mean you want to generate multiple different templates by using a SAS macro program to generate the differing templates. Or, if you are using the Graph Template Language, do you mean you want to use the dynamic MVAR statement to define variables (macro variables) to make the template more flexible?

Please review pages 20/21 of this paper https://support.sas.com/resources/papers/proceedings09/227-2009.pdf and note how the MVAR statement defines the macro variable &WANTY which alters the variable used for the bar chart's Y axis.

The answer to your question really depends on what it is EXACTLY that you need to do and what you mean by having PROC TEMPLATE "in macro".

cynthia
Super Contributor
Posts: 252

Re: Proc Template with MACRO

Hi, 

 

It's not clear on whether you need to use the NMVAR, MVAR or DYNAMIC statements within GTL, or if you need to use GTL with a SAS MACRO. Can you please show your code, and/or let us know how you are outputting each of these variables?

 

Many thanks,

 

Kriss

Super User
Posts: 19,086

Re: Proc Template with MACRO

It sounds like you're using PROC TEMPLATE incorrectly, but you haven't provided us enough information to tell you where or how to fix it. Really all you've stated is that somethings not working...

 

PROC TEMPLATE supports dynamic variables and should be a 'template' that can be reused so I suspect you're using it incorrectly or not using all the features available. 

Ask a Question
Discussion stats
  • 4 replies
  • 197 views
  • 1 like
  • 5 in conversation