i want to produce Information Value (IV) for a continuous variable using the proc hpbin   However, i need to estimate the IV per monthid and not sure how to group by in the hpbin procedure   Below is an example how my data looks like and at the bottom it is my code   MonthID Var1 Var2 1 1 1 1 2 1 2 3 0 2 4 0 2 5 1 3 6 0 3 7 0 4 8 1 4 9 1 4 10 1 5 11 1 5 12 1                         %macro IV_continuous; proc hpbin data = data1 numbin = 10; input var1; ods output mapping = binning; run; proc hpbin data = data1 woe bins_meta=binning; target var2; ods output infovalue = continuous_iv_10 woe =continuous_woe_table_10; run; %mend; ... View more

hi, i am trying to find the % of missing in a number of character variables in monthly basis   my problem is var2 has no missing values and creates an empty table (miss_a) which is this one with headers:   month var2 COUNT PERCENT   I want when miss_a is empty then to add in column PERCENT = 0. However, no action to be taken if miss_a is NOT empty   i would prefer this to be in a separate step rather than in proc freq      data A; input month $ var1 $ var2 $; datalines; 1 2 5 1 . 8 1 . 7 1 5 2 2 7 0 3 3 2 3 2 9 3 . 2 4 7 4 4 . 5 5 6 2 5 2 2 5 . 3 5 2 2 5 . 4 6 8 2 6 2 2 run; proc freq data=A; table var2 / noprint missing out=miss_a; WHERE var2=""; by month; run;   ... View more

hi, the below code prints the results even thought i have places ods close statement.   I mean it print in HTML which i don't want    Could you please anyone advise how to stop printing ?   /*R_squared*/ ods html close; proc logistic data=data1.; ods Output rsquare=r2.; model bad=good/rsquare; run; ods html close; ... View more

hi, i have the below    i want the output "a" table to extract the R2 (rsquare)    Is there any way to do this ?   proc logistic data=mydataset; model bad=INTEREST_RATE/rsquare; Output out=a; run;       ... View more

I try to count var1 when it is less than l_outlier however, the proc sql returns 1 in all cases    this is table b  var1 l_outlier l_outl_vol 1 5 1 2 1 1 3   1 4   1 5   1   i want the below. This is count var1 when it is less than l_outlier and not take in consideration the missing values    var1 l_outlier l_outl_vol 1 5 1 2 1 0 3   0 4   0 5   0     data a; input var1 l_outlier; datalines; 1 5 2 1 3 . 4 . 5 . ; run; proc sql; create table b as select *, sum (case when var1 < l_outlier then 1 else 0 end) as l_outl_vol from a; quit; ... View more