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
- 10317 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 is the difference between class statement and by statement in proc means?
Have you used macros? For what purpose you have used? : sas-macro
What is the basic structure of a sas program?
What are the implications?
What are the scrubbing procedures in sas?
describe the interaction table in sas di? : Sas-di
Explain how you can debug and test your SAS program?
What are the features of SAS?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is SAS?
how would you create multiple observations from a single observation? : Sas programming
Tell e how how dealt with..
What commands are used in the case of including or excluding any specific variables in the data set?
For clinical entire study how many tables will create approx?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
