proc sql;
select * from shareef.emp;
where deptno='20';
quit;
I was trying to run this code on sas9.2. Both where as well as having and order by not workig. However I get all departments in the output. Also following message in the log
Any suggestions why it won't work.
Thanking you.
Mohammed Shareef
7 where deptno='20';
WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.
8 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.20 seconds
cpu time 0.14 seconds
Well to start you have an additional ;
proc sql;
select * from shareef.emp; <- remove this colon.
where deptno='20';
quit;
Well to start you have an additional ;
proc sql;
select * from shareef.emp; <- remove this colon.
where deptno='20';
quit;
proc sql;
select * from shareef.emp; <- remove this colon.
where deptno= 20 ;
quit;
This one worked.
Thank you RW9.
Momin
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.
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.