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

[rajuganesh30]

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 · Accepted solution]

Something like

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

?

[rajuganesh30]

Thanks for the Answer

[Bhushan]

@rajuganesh30-

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