Hi,    I have a prompt with static list. When I run it creates the following variables:    %LET Selected_Scenarios_count = 3; %LET Selected_Scenarios0 = 3; %LET Selected_Scenarios = Base; %LET Selected_Scenarios3 = Down; %LET Selected_Scenarios2 = Up; %LET Selected_Scenarios1 = Base;   I am trying to execute a part of the code only for the Up and Down scenarios. However it runs for all the scenarios. Moreover it does not do the calculation. I am also sharing the input and output data with only 100 rows. My goal is to have only two additional columns with "Naming_Up" and "Naming_Down" calculated.    %macro my_sample(); data WORK.my_output; set WORK.my_source; %do h=1 %to &Selected_Scenarios_count.; if &&selected_scenarios&h.. in('Up','Down') then Naming_&&selected_scenarios&h..=field1*field2; %end; run; %mend my_sample; %my_sample();   ... View more

Hi all,   I have a question for using "if statement". I created a static list prompt. When selected, prompt outputs following variables:    %LET Selected_Scenarios_count = 3; %LET Selected_Scenarios = Base; %LET Selected_Scenarios0 = 3; %LET Selected_Scenarios3 = Down; %LET Selected_Scenarios1 = Base; %LET Selected_Scenarios2 = Up;   Here I share a sample piece of my code. I am using proc sql within sas macro. In the bold part I wish to calculate only for the Up and Down scenarios. However the code runs for all the scenarios.    Can you help? %macro MY_SAMPLE(); proc sql; create table WORK.MY_SAMPLE_TABLE as select Field1, Field2, %do s=1 %to &Selected_Scenarios_count.; sum(Name_&&selected_scenarios&s..) as Name_&&selected_scenarios&s.., if &&selected_scenarios&s.. in('Up', 'Down') then do; sum(Name3_&&selected_scenarios&s.._Y&y.) as Name3_&&selected_scenarios&s.., %end; %end; Field5 from WORK.MY_SOURCE group by 1,2 ;quit; %mend MY_SAMPLE; %MY_SAMPLE(); ... View more

Hi all,   I have a question for using sas variables dynamically. I created a static list prompt. When selected, prompt outputs following variables:    %LET Selected_Scenarios_count = 3; %LET Selected_Scenarios = Base; %LET Selected_Scenarios0 = 3; %LET Selected_Scenarios3 = Down; %LET Selected_Scenarios1 = Base; %LET Selected_Scenarios2 = Up;   my variables are working perfectly but I wish to call them dynamically. I wrote the code below but it is not functioning. My question: How can I use the variables within a dynamic loop?   %do i=1 %to &Selected_Scenarios_count.; Name_&selected_scenarios&i.=value; /*Trying to name the column with respect to variable. eg:'Down'*/ %end;   Thanks. ... View more