Hi Reeza, I wish I was a bit more articulate when it comes to Eminer. So the user has built a model using a sample dataset that he split 80:20 for training and validation. Now he wants to use this model on real world data to be able to score for each observation in the dataset. So, I just discussed with the user and he says he tried the score option like the SAS user documention page (also suggested above by Jaap) but it gives him source code in C /Java and summary statistics but no "scored dataset" per say. So, we were wondering how to get the scored dataset. ... View more

Hi Jaap, Do you know if it is the same procedure whether the dataset is training or external? Thanks, Raj. ... View more

Many thanks Tom. ... View more

Many thanks Vince28. I think copying the exact syntax seems to work. Even " &j " or "&j." will not work. ... View more

Hi Vince, I think I am still tripping up with getting the right syntax for checking macros. I have attached the code and log. I am trying to check if the macro variables i and j have values then create the ALLDATA dataset. For all other values of i and j, merge (not append) the data from &&pcode&i.._LINE_DELTA_&&metric&j.. into the ALLDATA dataset. %if  (%eval("&j ") = "1" AND %eval("&i" ) ="1" )  %then   %do;   DATA ALLDATA;   set &&pcode&i.._LINE_DELTA_&&metric&j..;   run;   %end ; %else %if ( %eval("&j" ) <> "1" OR  %eval("&j" ) <>"1" ) %then   %do;   PROC SQL;   create table ALLDATA   as (select * from &&pcode&i.._LINE_DELTA_&&metric&j.. t1   right  join CUSTOMHRBIN_VALUES t2    on (t1._&&pcode&i.._CustomHrBinA=t2._customhrbin    or t1._&&pcode&i.._CustomHrBinB=t2._customhrbin)   union select * from WORK.ALLDATA    )    ;   quit;   %end; SYMBOLGEN:  Macro variable J resolves to 1 ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:        "1 " SYMBOLGEN:  Macro variable I resolves to 3 ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:        "3" MLOGIC(_LOOP_FOR_SELECTED_PROCESSES._PROCESS_LEGS._METRICS):  %IF condition (%eval("&j ") = "1" AND %eval("&i" ) ="1" ) is FALSE ERROR: The macro _METRICS will stop executing. MLOGIC(_LOOP_FOR_SELECTED_PROCESSES._PROCESS_LEGS._METRICS):  Ending execution. MLOGIC(_LOOP_FOR_SELECTED_PROCESSES._PROCESS_LEGS):  %DO loop index variable J is now 2; loop will iterate again. 60                                                         The SAS System                              09:06 Thursday, July 25, 2013 MPRINT(_PROCESS_LEGS):   *loop through individual metric; MLOGIC(_LOOP_FOR_SELECTED_PROCESSES._PROCESS_LEGS._METRICS):  Beginning execution. SYMBOLGEN:  && resolves to &. SYMBOLGEN:  Macro variable J resolves to 2 SYMBOLGEN:  Macro variable METRIC2 resolves to Voc ... View more

Thanks eveyone. I have a question related to sas nested macros. I have two processes that I need to run the outer macro for and two metrics that I need to run the inner macro loop for. Originally I had the macro logic like this. Is that correct? Data MESTGT.include_processes; length pname $20.; input pname; cards; FinalSim AcidEtch run; Data MESTGT.include_metrics; length metricname $20.; input metricname; cards; Total_eff Voc ; run; Data _null_; set MESTGT.include_processes; call symput ('pcode'||strip(_n_),strip(pname)); call symput ('nproc', strip(_n_)); run; Data _null_; set MESTGT.include_metrics; call symput ('metric'||strip(_n_),strip(metricname)); call symput ('nmetric', strip(_n_)); run; %macro _process_legs (pcode=); ....     %macro _metrics     %mend _metrics;     /**Loop Through each individual metric for a single process leg**/    %do j= 1 %to &nmetric; *loop through individual metric;    %_metrics(metric=&&metric&j..) %end; %mend _process_legs; /**Control Loop**/ %macro _loop_for_selected_processes; %let i= ; /****loops through individual leg/process***/ %do i = 1 %to &nproc; %let j=; %_process_legs(pcode=&&pcode&i..) %end; %mend _loop_for_selected_processes; %_loop_for_selected_processes ... View more

Many thanks. I think it fixed the error. The pitfalls of copying and pasting and not thinking. ... View more