data AGE;
set B;
where AGE =>65 OR AGE<12;
run;
I want to have a dataset with records that have AGE=>65 or AGE<12, but the above code doesn't work.
I get this in the log:
_ | |
22 | |
76 |
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, INPUT, PUT. |
ERROR 76-322: Syntax error, statement will be ignored.
You need >= or (and I never say always but) I always use mnemonics GE.
To avoid confusion with those symbols, I always use GE for >= (Greater than or Equal to) and LT for < (Less Than).
Thanks!
Thanks for all the helpful comments.
But now I notice that I have some records with Age=.
So now I want age that are also 0=<AGE<12.
Thanks
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.