topic Re: proc tabulate -where statement in SAS Programming

proc tabulate -where statement

archibald — Thu, 02 Jun 2016 01:56:30 GMT

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.

Re: proc tabulate -where statement

archibald — Thu, 02 Jun 2016 01:58:03 GMT

Updates:

proc tabulate data= new;

where sex=2 and grade ne 3;

ERROR: WHERE clause operator requires compatible variables.

Re: proc tabulate -where statement

PGStats — Thu, 02 Jun 2016 02:13:16 GMT

One or both of your variables is character, so either

where sex='2' and grade ne 3;

where sex=2 and grade ne '3';

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

Re: proc tabulate -where statement

Reeza — Thu, 02 Jun 2016 02:25:05 GMT

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.

Re: proc tabulate -where statement

archibald — Sun, 05 Jun 2016 23:40:46 GMT

Thank you PGStats!