Can we use where and having clauses in a single SAS program. ex: proc sql; &

Can we use where and having clauses in a single SAS program.

ex: proc sql;
select a,b,c from test
where state in 'KA'
and having <some condition>.

Is the above program run correctly, if not why ?

Question Posted / siddu_adike

4 Answers
9384 Views
UHG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we use where and having clauses in a single SAS program. ex: proc sql; select ..

Answer / rauthu

Yes, WHERE and HAVING can be used in single program. HAVING must be after GROUP by clause.
Example:
proc sql;
select make, model, avg(msrp) as avgmsrp, msrp
from sashelp.cars
where make ='Honda'
group by model
having avgmsrp < 100000;
quit;

Is This Answer Correct ?

9 Yes

1 No

Can we use where and having clauses in a single SAS program. ex: proc sql; select ..

Answer / rajasekaran

having statement should mentioned after group by statement only

proc sql;
select a,b,c from test
where state in 'KA'
group by xyz
and having <some condition>.

Is This Answer Correct ?

3 Yes

1 No

Can we use where and having clauses in a single SAS program. ex: proc sql; select ..

Answer / a.k.naidu

Having clause can be used only with 'group by'. Difference between 'where' and 'having' is that former works on variable level and latter works on observation level. 'having' works like second where condition on "grouped data"

Is This Answer Correct ?

2 Yes

0 No

Can we use where and having clauses in a single SAS program. ex: proc sql; select ..

Answer / santhosh

worng

Is This Answer Correct ?

1 Yes

7 No

Post New Answer