About u58497688

whymath · ‎10-26-2021

It's about table lookup skill and if statement. data test; input Variable$ var1$ var2$ p_value p_gain; cards; A1_B1 A1 B1 0.02 . A1_B2 A1 B2 0.3 . A1 A1 . 0.06 . A2 A2 . 1 . B1 . B1 0.0007 . ; run; data want; set test; if find(Variable,'_') then do; do i = 1 to rec; set test(keep=Variable p_value rename=(Variable=tmpVariable p_value=tmppvalue))nobs=rec point=i; if var1 = tmpVariable then var1pvalue = tmppvalue; if var2 = tmpVariable then var2pvalue = tmppvalue; end; if . < var1pvalue < p_value then p_gain = var1pvalue/p_value; if . < var2pvalue < p_value then p_gain = var2pvalue/p_value; end; drop tmp:; run;

ballardw · ‎08-30-2021

@u58497688 wrote: Thanks, i just added an output, so I could work with it further. If it helps anyone else: proc means mean data=have; class ID; var TotalScore; output out=means_totalscore mean=mean_totalscore; run; Your output data set will have a variable _type_ indicating combinations of the Class variable. The _type_=0 will be the mean for all the ID values. If you do not want that in the output then add NWAY to the Proc statement to select only the highest type which would have the combinations for the class variable(s) and none of the other summaries. This is actually useful behavior but there is a learning curve about the various options controlling the output with class variables. There will also be a _freq_ variable indicating how many observations were used for each statistic.

Online Status	Offline
Date Last Visited	‎10-26-2021 12:32 PM

p gain method

Re: Proc means for two levels

Proc means for two levels

Re: p gain method

Re: Proc means for two levels