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
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.