topic Re: Resolving Macro Variables that contain macro variables in SAS Programming

Resolving Macro Variables that contain macro variables

KDLiwen — Wed, 14 Oct 2015 20:04:47 GMT

I have created a list of macro variables in a PROC SQL without error. When I create the macro variables I have a list of parameters (costval) that I have created previosuly in the job. I cannot hard code these values because they may change and I want the flexibility to pick up any new ones that are added. I am having trouble getting the syntax right to get these values to resolve in a DATA step further down the line. How do I get these costvals to resolve? Any help would be appreciated.

proc sql noprint ;
select %do i = 1 %to &costvars ;
sum(CC_&&costval&i),
%end ;
count(*), sum(TotalGTM)
into
%do i = 1 %to &costvars ;
:ccE&&costval&i,
%end ;
:ccETotal, :ccEmptyGTM
from work.emptycc ;
quit ;

Re: Resolving Macro Variables that contain macro variables

Astounding — Wed, 14 Oct 2015 20:26:52 GMT

You might find it easier if you change the names of the macro variables that SQL creates.

You have:

:ccE&&costval&i,

Try:

:ccE_&i,

You would still have &costval1 - &costvalN that tells you how the numbers relate to the original field names.

Good luck.

Re: Resolving Macro Variables that contain macro variables

ballardw — Wed, 14 Oct 2015 20:28:10 GMT

Hard to tell what may be going on. Have you tried using options mprint or adding a %put _user_; statement after the proc sql to see what your code is resolving to?

Are you getting any errors? If so what are they?