Thank you so much Tom for your great advice! You are right, I specified the length to $9 and it worked! That was all the issue ... View more

I found out what  the problem was. Even though I entered the var level as 464918_99, SAS was reading it as 464918_9 so when I used 464918_9 instead of 464918_99 in the WHERE statement it worked.    Thanks for your guidance Tom. ... View more

Thank you very much for your help Cynthia. For some reason, SAS  is not reading '464918_99' in the WHERE statement. ... View more

Thanks for your reply Tom. In proc freq SAS is not reading '464918_99' either, only 'Hass'.  ... View more

Thank you so much Ksharp, thats exactly what I wanted! ... View more

Oh that's right, thank you very much for the clarification.  I tried this code including stat=percent and I think this graph makes more sense to me: proc sgpanel data=one ; where Variety in('BL516','Hass'); panelby Season / columns=4 onepanel; vbar Variety / group=PeelColor stat=percent groupdisplay=stack seglabel /*seglabelattrs=(size=12 color=white)*/;  run; The percentages labeled are total percentages from all seasons. ... View more

Great, thanks! ... View more

Thanks. So should I use the Fisher's exact test (two -sided Pr<=P) in case the cell counts are too small, but otherwise the Chi square test I get with the chisq option? ... View more

I have a question; Is the two-sided Pearson chi-square test  in the Fisher's Exact Test Table the one that will tell me if  the proportions for ColorRed (1) are significantly different between the two Varieties?    Frequency Percent Row Pct Col Pct Table of Variety by Colorred Variety Colorred 0 1 Total BL516 224 37.27 74.42 44.01 77 12.81 25.58 83.70 301 50.08     Hass 285 47.42 95.00 55.99 15 2.50 5.00 16.30 300 49.92     Total 509 84.69 92 15.31 601 100.00   Statistics for Table of Variety by Colorred Statistic DF Value Prob Chi-Square 1 49.0915 <.0001 Likelihood Ratio Chi-Square 1 53.0439 <.0001 Continuity Adj. Chi-Square 1 47.5168 <.0001 Mantel-Haenszel Chi-Square 1 49.0098 <.0001 Phi Coefficient   -0.2858   Contingency Coefficient   0.2748   Cramer's V   -0.2858   Fisher's Exact Test Cell (1,1) Frequency (F) 224 Left-sided Pr <= F <.0001 Right-sided Pr >= F 1.0000     Table Probability (P) <.0001 Two-sided Pr <= P <.0001 ... View more

Thank you very much Ksharp for this useful option! ... View more

Thank you so much for your reply StatDave, that makes sense.   I will then apply these steps for every level of the dep var PeelColor I'm interested in, in order to get a 2x2 table:   data one1; set one; if PeelColor=3 then ColorRed=1; else ColorRed=0; run;   proc freq data=one1; where Season=2021 and Variety in('BL516', 'Hass'); table Variety*colorRed/chisq riskdiff; run; ... View more