BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
momin
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well to start you have an additional ;

proc sql;

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

where deptno='20';

quit;

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well to start you have an additional ;

proc sql;

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

where deptno='20';

quit;

momin
Calcite | Level 5

proc sql;

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

where deptno= 20 ;

quit;

This one worked.

Thank you RW9.

Momin

sas-innovate-2024.png

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.

 

Register now!

What is ANOVA?

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.

Discussion stats
  • 2 replies
  • 4443 views
  • 2 likes
  • 2 in conversation