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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.