151 proc print data = payments;
152 where department ? M;
ERROR: Variable M is not on file WORK.PAYMENTS.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The WHERE statement involves a variable named M, which does not exist in the Work.PAYMENTS dataset. This is a syntax error so no observations are written. The correct WHERE statement syntax would be, where department ? 'M'; (the quotations indicate a text value).
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.