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
- 10357 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 the 3 components in sas programming?
Describe the ways in which you can create macro variables? : sas-macro
What is a macro routine?
Mention few capabilities of sas framework.
how are numeric and character missing values represented internally? : Sas programming
How to create a permanent sas data set?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
Explain how merging helps to combine data sets.
explain the use of % includes a statement in sas? : Sas-administrator
How necessary is it to be creative in your work?
For clinical entire study how many tables will create approx?
How does proc sql work?
What is the difference between order and group variable in proc report?
What is a put statement?
What do you know about sas data set?
