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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.