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
- 10494 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 is the maximum length of the macro variable?
What commands are used in the case of including or excluding any specific variables in the data set?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
How many ways to overcome a missing values???
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is sas data set?
Have you ever used the SAS Debugger?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
How to limit decimal places for variable using proc means?
how do the in= variables improve the capability of a merge? : Sas programming
explain about sas business intelligence? : Sas-bi
Give e an example of..
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What is the basic structure of a sas program?
