The file I attached is the output from another function (i.e., not required to read the file in the above code). I attached sample data for reference. ... View more

Attached the sample dataset and 3 macros I am trying to run:   %Macro ApplyTrees(TotalTrees); %Do TreeCount = 1 %To &TotalTrees.; %CreateChoices(&TreeCount.); proc sql noprint; select Prediction into :PredictedValue separated by "|" from Tree_&TreeCount.; quit; Data _NULL_; Set Tree_&TreeCount.; Call Symput("NodeCount", Compress(_N_)); Run; %ApplyChoices(&TreeCount.); %End; %Mend ApplyTrees; %Macro CreateChoices(TreeCount); %Do x = 1 %To 5; %Global ChoiceList&x.; %Global VariableList&x.; proc sql noprint; select Decision&x. into :ChoiceList&x. separated by "|" from Tree_&TreeCount.; quit; proc sql noprint; select InSplitVar&x. into :VariableList&x. separated by "|" from Tree_&TreeCount.; quit; %End; %Mend CreateChoices; %Macro GetCheck(VariableList, ChoiceList, c); %Let InSplitVar = %Scan (%bquote(&&&VariableList.), &c., %str(|)); %Let Decision = %Scan(%bquote(&&&ChoiceList.), &c., %str(|)); and &InSplitVar. &Decision. %Mend GetCheck; %Macro GetCheck(VariableList, ChoiceList, c); %Let InSplitVar = %Scan (%bquote(&&&VariableList.), &c., %str(|)); %Let Decision = %Scan(%bquote(&&&ChoiceList.), &c., %str(|)); and &InSplitVar. = %str(&Decision.) %Mend GetCheck; %Macro ApplyChoices(TreeCount); Data OutSample; Set OutSample; %Do b = 1 %To &NodeCount.; If 1 = 1 %Do a = 1 %To 5; %GetCheck(VariableList&a., ChoiceList&a., &b.) %End; %Let Prediction = %Scan(&PredictedValue., &b., %str(|)); Then PredictedValue_&TreeCount. = "&Prediction."; %End; Run; %Mend ApplyChoices; %ApplyTrees(1);   ... View more