BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AZIQ1
Quartz | Level 8

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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.

View solution in original post

1 REPLY 1
Reeza
Super User

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.

sas-innovate-2024.png

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.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 1 reply
  • 749 views
  • 1 like
  • 2 in conversation