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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.