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.
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';
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.
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';
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.