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
- 9584 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is sas business intelligence? : Sas-bi
What is the difference between %put and symbolgen? : sas-macro
what is hierarchy flattening? : Sas-di
What are the five ways to do a table lookup in sas? : sas-grid-administration
Describe the ways in which you can create a macro variable?
Explain bmdp procedure?
what does the run statement do? : Sas programming
What is the purpose of trailing @ and @@? How do you use them?
What is data _null_?
Which command is used to perform sorting in sas program?
Give e an example of..
explain the use of % includes a statement in sas? : Sas-administrator
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Describe the ways in which you can create macro variables?
