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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.