Macro for a changing value in a calculation

AZIQ1 — Mon, 18 Jan 2016 21:04:36 GMT

Hi,

I want to use a different value (number) for my formula everytime. Is there a way I can write a simple macro eg:

newvar=(oldvar- 9) x var2

the number 9 will change to 3, 6, and different values?

Help

Thanks

Re: Macro for a changing value in a calculation

Reeza — Mon, 18 Jan 2016 21:14:19 GMT

Yes, is there any pattern to the changes though?

How do you plan to execute each of your values?

Are you creating new_var that needs to be unique for each value? If so, how is each identified?

Are you creating a new data set that needs to be unique for each value? If so, how is each data set identified?

The gist is create a macro variable..

%let constant=9;

newvar=(oldvar-&constant) * var2;

Change constant, run the data step and newvar will change.