topic Re: How to change the value stored in the macro variable change dynamically based on a condition? in SAS Programming

How to change the value stored in the macro variable change dynamically based on a condition?

rajuganesh30 — Sat, 10 Mar 2018 09:48:21 GMT

Hello Guys,

I have a dataset with a variable called "ENVIRONMENT", the values will in it would be either "UAT" or "PROD", but not both the values.

I want to store the value in a macro variable.

eg. if the dataset has a value of "UAT" stored today the macro variable should resolve to "UAT".

if the next extract of dataset tomorrow contains "PROD" i want the macro variable to resolve to "PROD"

Can anyone please help me out?

Kurt_Bremser — Sat, 10 Mar 2018 10:53:01 GMT

Something like

data _null_;
set have (obs=1);
call symputx('macrovar',environment);
run;

rajuganesh30 — Sat, 10 Mar 2018 11:12:34 GMT

Thanks for the Answer

Bhushan — Sat, 10 Mar 2018 13:50:58 GMT

is there anything in your dataset which can trigger extraction or Data refresh is happening for UAT Or PROD environment?

If yes then we can change macro variables value dynamically o.w we need to pass macro parameters