topic Re: ERROR ..... BINOMIAL LEVEL= value in Statistical Procedures

topic Re: ERROR ..... BINOMIAL LEVEL= value in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605257#M29396 <P>program works except for some combinations.</P><P>i'm trying to find a way for SAS to compute freq for valid combinations without using the WHERE CLAUSE 16 times </P> Tue, 19 Nov 2019 00:19:31 GMT malls 2019-11-19T00:19:31Z ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605249#M29394 <P>Hi,</P><P> </P><P>I am trying to generate frequencies binomial CI for my response data using below code.</P><P>Sadly i'm getting errors when i have only one category(resp='0') in response variable for some categories of by variable.</P><P>Can anyone help me with this please ?</P><P>thanks</P><P> </P><P> </P><P>proc sort data=wis.liv OUT= wis.liv_freq; by lev cph ; run;</P><P> </P><P>ods output Binomial=Binomial;</P><P>proc freq data = wis.liv_freq;</P><P>tables SURG / binomial(level=2);</P><P>by lev cph;</P><P>run;</P><P> </P><P> </P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=1 cph=h2</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=1 cph=h3</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=2 cph=h4</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=2 cph=h7</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h12</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h13</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h19</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h22</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h23</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h24</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h25</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h27</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=3 cph=h29</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=4 cph=h39</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=4 cph=h51</P><P>ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG.</P><P>NOTE: The above message was for the following BY group:</P><P>      lev=4 cph=h58</P><P>NOTE: The SAS System stopped processing this step because of errors.</P><P>WARNING: The data set WORK.BINOMIAL may be incomplete.  When this step was stopped there were 16</P><P>         observations and 7 variables.</P> Mon, 18 Nov 2019 23:46:47 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605249#M29394 malls 2019-11-18T23:46:47Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605255#M29395 <P>You can't compute anything from data where your variable SURG takes on only the value '0' and no other value.</P> <P> </P> <P> </P> Tue, 19 Nov 2019 00:16:28 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605255#M29395 PaigeMiller 2019-11-19T00:16:28Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605257#M29396 <P>program works except for some combinations.</P><P>i'm trying to find a way for SAS to compute freq for valid combinations without using the WHERE CLAUSE 16 times </P> Tue, 19 Nov 2019 00:19:31 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605257#M29396 malls 2019-11-19T00:19:31Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605260#M29397 <P>You would have to weed out these levels where there is only one value in a data step (or PROC) before your run PROC FREQ.</P> Tue, 19 Nov 2019 00:24:59 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605260#M29397 PaigeMiller 2019-11-19T00:24:59Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605261#M29398 <P>many thanks </P><P>i'll try this </P> Tue, 19 Nov 2019 00:27:05 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605261#M29398 malls 2019-11-19T00:27:05Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605372#M29402 <P>A suggestion would be to take advantage of the WEIGHT statement with the ZEROS option.  You could begin by taking your existing data set and assigning a count of 1.</P> <P> </P> <P>data wis.liv_freq;</P> <P>set wis.liv_freq;</P> <P>ct=1;</P> <P>run;</P> <P> </P> <P> </P> <P>Once you do that, you could then create a data set that has all the combinations of the BY variables and the SURG variable and assign a count of 0 to each observation.</P> <P> </P> <P>data all;</P> <P>do lev=  *assign the levels of lev here;</P> <P>do cph=...;</P> <P>do surg=...;</P> <P>ct=0;</P> <P>output;</P> <P>end;</P> <P>end;</P> <P>end;</P> <P> </P> <P>Now if you stack those two data sets together and sort them</P> <P> </P> <P>data wis.liv_freq2;</P> <P>set wis.liv_freq all;</P> <P> </P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">proc sort data=wis.liv_freq2;</SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> by lev cph ; </SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">run;</SPAN></P> <P> </P> <P>Then you should be able to use the WEIGHT statement in Proc FREQ.</P> <P> </P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">proc freq data = wis.liv_freq2;</SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">weight ct/zeros;</SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">tables SURG / binomial(level=2);</SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">by lev cph;</SPAN></P> <P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">run;</SPAN></P> <P> </P> <P> </P> Tue, 19 Nov 2019 12:51:37 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605372#M29402 SAS_Rob 2019-11-19T12:51:37Z Re: ERROR ..... BINOMIAL LEVEL= value https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605421#M29405 <P>Both methods works perfectly </P><P>thanks all</P> Tue, 19 Nov 2019 15:35:12 GMT https://communities.sas.com/t5/Statistical-Procedures/ERROR-BINOMIAL-LEVEL-value/m-p/605421#M29405 malls 2019-11-19T15:35:12Z