proc tabulate -where statement

[archibald]

I want to select  all female students in all grades except grade 3 to run a proc tabulate, but  I am getting this error . Is there a solution to this without listing grade 1,2,4,5,6,and 7 in the "where" statement. Thank you.

proc tabulate data= new;

 where  sex=2 and grade ne 2;

ERROR: WHERE clause operator requires compatible variables.

[archibald]

Updates:

I want to select  all female students in all grades except grade 3 to run a proc tabulate, but  I am getting this error . Is there a solution to this without listing grade 1,2,4,5,6,and 7 in the "where" statement. Thank you.

proc tabulate data= new;

 where  sex=2 and grade ne 3;

ERROR: WHERE clause operator requires compatible variables.

[archibald]

Updates:

I want to select  all female students in all grades except grade 3 to run a proc tabulate, but  I am getting this error . Is there a solution to this without listing grade 1,2,4,5,6,and 7 in the "where" statement. Thank you.

proc tabulate data= new;

 where  sex=2 and grade ne 3;

ERROR: WHERE clause operator requires compatible variables.

[PGStats · Accepted solution]

One or both of your variables is character, so either

 where  sex='2' and grade ne 3;

or

 where  sex=2 and grade ne '3';

or

 where  sex='2' and grade ne '3';

[archibald]

Thank you PGStats!

[Reeza]

Character values need quotes

To test for multiple grades use IN e.g. Grades in (2 3 4 5 6 7). If character all the grade values should be enclosed in quotes.