Macro Variable call in a macro

sai99 — Thu, 22 Feb 2018 17:16:58 GMT

Unable to call macro loadcpddata in macro loading:

data cpdlogic (sortedby=CPDCOBRS_VAR_NM CPDCOBRS_GRP_T);

set loaddata.cpdlogic;

if CPDCOBRS_CATG_T='CPD_logic' then do;

FieldCounterChar = left(put(_n_,6.));

FieldCounter = _n_;

output;

end;

run;

proc sql noprint;

select max(FieldCounter) into :TotalFieldCount

from cpdlogic ;

quit;

%put &TotalFieldCount;

%macro LoadCPDData (Group,Field_Num);

proc sql noprint;

select CPDCOBRS_VAR_NM into :FieldName

from cpdlogic

where CPDCOBRS_GRP_T=&Group

and FieldCounter=&Field_Num;

quit;

%put [&Field_Num];

%global &FieldName;

proc sql noprint;

select CPDCOBRS_RTRN_VLU_1 into :&FieldName

from cpdlogic

where CPDCOBRS_GRP_T=&Group;

quit;

%mend LoadCPDData;

%macro loading;

%if &TotalFieldCount > 1 %then %do;

%do i=1 %to &TotalFieldCount;

%LoadCPDData(&cpd,&i);

%end;

%mend loading;

DATA:

Re: Macro Variable call in a macro

Astounding — Thu, 22 Feb 2018 17:34:32 GMT

You're not very specific about what happens when you try to run this. However, here's an issue that stands out.

For %LoadCPDData(&cpd,&i) to work, there must be an existing macro variable named CPD. I don't see how your program creates that.