topic Re: %macro ( ctr , num) in SAS Studio

%macro ( ctr , num)

IBNANA — Wed, 27 Jun 2018 09:05:56 GMT

I have a question on the use of %macro. I am using the code of a published paper to build my own indicator and I faced many problems.

Code :

%macro decomp(ctr,num);
proc iml;
use vbs;
read all var _all_ into vbs;
use texpfd(drop = ctr sec domdmd texpfd) ;
read all var _all_ into expf;
/*make DVAsh to zero */
k = 0;
do i = 1 to 1435 by 35;
j = i+34;

k = k + 1;
rows = i:j;
cols = k:k;
vbs[rows,cols] = 0;
end;
indvaexp=vbs[,&num]#expf;

quit;

%mend decomp

my problem is %macro (ctr ,num) . Is num refering to the fact that it is a numeric variable ?

and the last code indvaexp=vbs[,&num]#expf. What is the meaning of vbs[,&num] . I know that we use & to make reference to a macro variable but I tried to compute without macro ( indvaexp=vbs#expf) but I don't get the same result .

Can you help me please ?

Re: %macro ( ctr , num)

Kurt_Bremser — Wed, 27 Jun 2018 10:50:23 GMT

%macro decomp(ctr,num);

Here, num is just defined as the second positional parameter of the macro. You can reference it just like any locally defined macro variable throughout the macro.

indvaexp=vbs[,&num]#expf;

Here &num is referenced. When the macro resolves and is executed by the macro preprocessor, &num is replaced by whatever was supplied as a parameter when the macro was called.

%decomp(x,y)

will resolve this particular line to

indvaexp=vbs[,y]#expf;

Think of the macro preprocessor as a quite versatile text replacement tool.

Re: %macro ( ctr , num)

ballardw — Wed, 27 Jun 2018 14:44:49 GMT

@IBNANA wrote:

I have a question on the use of %macro. I am using the code of a published paper to build my own indicator and I faced many problems.

Code :

%macro decomp(ctr,num);
proc iml;
use vbs;
read all var _all_ into vbs;
use texpfd(drop = ctr sec domdmd texpfd) ;
read all var _all_ into expf;
/*make DVAsh to zero */
k = 0;
do i = 1 to 1435 by 35;
j = i+34;

k = k + 1;
rows = i:j;
cols = k:k;
vbs[rows,cols] = 0;
end;
indvaexp=vbs[,&num]#expf;

quit;

%mend decomp

my problem is %macro (ctr ,num) . Is num refering to the fact that it is a numeric variable ?

and the last code indvaexp=vbs[,&num]#expf. What is the meaning of vbs[,&num] . I know that we use & to make reference to a macro variable but I tried to compute without macro ( indvaexp=vbs#expf) but I don't get the same result .

Can you help me please ?

If the paper you reference that gave you the base code did not document the usage of any of the macro parameters I would hesitate to rely on the paper or the code too much.

Especially if there are no validations of the parameters in regards to the data or code use. Any program should document the expected inputs somewhere such as a comment block. It should have some explanation of what the whole macro does and details of the macro parameters and if there isn't any validation of the parameter values then the validation you have to perform before using the macro.

Something of concern: there macro parameter CTR is apparently not even used. I would expect to see at least one reference to &ctr in the code.

Re: %macro ( ctr , num)

IBNANA — Thu, 28 Jun 2018 23:12:22 GMT

Thank you for your answer