topic proc sql query in Statistical Procedures

proc sql query

momin — Thu, 23 Oct 2014 15:02:47 GMT

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

Re: proc sql query

RW9 — Thu, 23 Oct 2014 15:06:29 GMT

Well to start you have an additional ;

proc sql;

select * from shareef.emp; <- remove this colon.

where deptno='20';

quit;

Re: proc sql query

momin — Thu, 23 Oct 2014 16:10:57 GMT

proc sql;

select * from shareef.emp; <- remove this colon.

where deptno= 20 ;

quit;

This one worked.

Thank you RW9.

Momin