proc sql query

[momin]

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

[RW9 · Accepted solution]

Well to start you have an additional ;

proc sql;

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

where deptno='20';

quit;

[momin]

proc sql;

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

where deptno= 20 ;

quit;

This one worked.

Thank you RW9.

Momin