Dear all,   I want to define recursively a data step inside of a macro but it it nos allow. I have the code below:   Anyone can help me to transform it in something that works? Thank you all   %do year=2017 %to 2019; %do month=1 %to 12; %do mod_id=8 %to 14; data calibracion_&year.&month.&mod_id._2; set test&year.&month.bmod_id&mod_id.; format flag_event $2.; flag_event = ind_incumplimiento; output; run; title 'Logistic Regression: M008'; proc logistic data=calibracion_&year.&month.&mod_id._2 descending; /* To model 1s rather than 0s, we use the descending option */ model flag_event = raw_logit / clparm=wald; ods output ParameterEstimates = calibration_&year.&month.&mod_id.; run; data _null_; set calibration_&year.&month.&mod_id.; if variable='Intercept' then call symputx('a_mod&year.&month.&mod_id',estimate); if variable NE 'Intercept' then call symputx('b_mod&year.&month.&mod_id',estimate); run; %end; %end;%end; %mend; %parametros     ... View more

Dear all,   I am beginner in SAS and I am developing a program in which I have to use parameters from a raw_table to compute another variable.    I mean, I have the table "parametros" and my aim is to calculate for each mod_id the formula below:   new_score= Par_A*raw_score + Par_B + (Par_C+Par_D)/raw_score   I do not how to select values from parametros to use in the code below.   Can anybody help me? Thank you in advance data parametros; input mod_id Par_A Par_B Par_C Par_D; datalines; 8 1.5340 -0.6896 0.0214 0.0211 9 0.6560 -0.7788 0.0169 0.0185 10 1.8773 -0.4354 0.0216 0.0227 11 0.8543 -0.8598 0.0258 0.0269 12 -0.5137 -0.9571 0.0213 0.0231 13 0.0979 -0.9629 0.0239 0.0258 14 0.8889 -0.7801 0.0136 0.0146 run; data mapping_table; mod_id=8; Do while (mod_id<15); raw_score=1600; Do while (raw_score<2201); new_score= Par_A*raw_score + Par_B + (Par_C+Par_D)/raw_score; output; raw_score+1; end; mod_id + 1; end; run; ... View more