Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10295 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
Name types of category in which SAS Informats are placed?
Which are the statements whose placement in the data step is critical?
What are the table names in oracle database...?
What are the default statistics for means procedure?
Mention the validation tools used in SAS?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What are all the problems you faced while validating tables and reports?
What is the use of function Proc summary?
What are the parameters of scan function?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What is data _null_?
Have you used macros? For what purpose you have used? : sas-macro
name some data transformation used in sas di? : Sas-di
what are the component of range? : Sas-bi
What are the limitations for memory allocation for SAS variables
