topic Re: PROC MIXED doesn't recognize all levels of class in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170954#M44163 <HTML><HEAD></HEAD><BODY><P>One quick check would be to do a proc freq and see if it gives two values.&nbsp; My initial guess is that all of one category is being excluded, either in a data step prior to analysis or by use of a WHERE statement.</P><P></P><P>Steve Denham</P></BODY></HTML> Fri, 23 May 2014 14:04:11 GMT SteveDenham 2014-05-23T14:04:11Z PROC MIXED doesn't recognize all levels of class https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170953#M44162 <HTML><HEAD></HEAD><BODY><P>The problem:</P><P>In PROC MIXED, I defined several classes under 'class'.</P><P></P><P>One of them, called 'Status', has two levels, coded as '1' and '2' (i.e. the column for these data consists of ones and twos). </P><P></P><P>When I run the program, the output states that the class 'Status' has one level, and that it's value is '2'</P><P></P><P>This happens even though I have several other classes with two levels coded as '1' and '2', (i.e., as for Status, the data are columns of ones and twos), for which the output correctly states that each of these classes has two levels, with the values '1' and '2'. </P><P></P><P>Anyone know how I can fix this?</P><P></P><P>PS: The data come from an Excel file, which I opened in SPSS and then saved with the .sas7bdat extension</P><P>PPS: I've already tried removing the entire 'Status' column in Excel and rewriting it. I've also tried coding the levels as letters (e.g. 'C' and 'P'), but the problem remains. </P></BODY></HTML> Fri, 23 May 2014 11:20:46 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170953#M44162 Reshi 2014-05-23T11:20:46Z Re: PROC MIXED doesn't recognize all levels of class https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170954#M44163 <HTML><HEAD></HEAD><BODY><P>One quick check would be to do a proc freq and see if it gives two values.&nbsp; My initial guess is that all of one category is being excluded, either in a data step prior to analysis or by use of a WHERE statement.</P><P></P><P>Steve Denham</P></BODY></HTML> Fri, 23 May 2014 14:04:11 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170954#M44163 SteveDenham 2014-05-23T14:04:11Z Re: PROC MIXED doesn't recognize all levels of class https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170955#M44164 <HTML><HEAD></HEAD><BODY><P>Many of the modeling procs will exclude records if any of the independent variables are missing. By any chance are other variables, alone or in combination, in the model missing for all of records with Status=2?</P><P></P><P>One of the output tables should also mention how many records were used. Does this match the number in your input data set?</P></BODY></HTML> Fri, 23 May 2014 15:17:58 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170955#M44164 ballardw 2014-05-23T15:17:58Z Re: PROC MIXED doesn't recognize all levels of class https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170956#M44165 <HTML><HEAD></HEAD><BODY><P>"By any chance are other variables, alone or in combination, in the model missing for all of records with Status=2?"</P><P>This was indeed the case. Thanks!</P></BODY></HTML> Mon, 26 May 2014 14:28:13 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-MIXED-doesn-t-recognize-all-levels-of-class/m-p/170956#M44165 Reshi 2014-05-26T14:28:13Z