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 ?
- 4 Answers
- 9065 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are several options for creating reports in web report studio? : Sas-bi
What is interleaving in SAS?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are symget and symput? : sas-macro
What is the role of administrative users? : sas-grid-administration
What is the basic syntax style in SAS?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Are you sensitive to code walk-throughs peer review or QC review?
How can sas program be validated?
how will you locate the sas platform applications? : Sas-bi
what is business intelligence? : Sas-bi
What is the basic structure of a sas program?
What is a put statement?
What do the mod and int function do? : Sas programming
