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
- 10157 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 validation tools used in SAS
Mention how to limit decimal places for the variable using proc means?
Which are the statements whose placement in the data step is critical?
what is sas olap server? : Sas-di
What does proc print, and proc contents are used for?
Can you suggest us materials for sdtm mapping?
what is intially documentation in sas?
What is the difference between reading data from an external file and reading data from an existing data set?
how will you locate the sas platform applications? : Sas-bi
How would you invoke a macro? : sas-macro
I need level 2 to 5 sas using companies in india
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What are the data types does SAS contain?
What is the difference between the proc sql and data step?
How would you determine the number of missing or nonmissing values in computations?
