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
- 10159 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
How to limit decimal places for variable using proc means?
What is PROC in SAS?
Are you involved in writing the inferential analysis plan? Tables specfications?
Explain the use of proc print and proc contents?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is the basic structure of the SAS base program?
What are the advantages of using sas?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is the primary data source for the wrs? : Sas-bi
Describe a time when you were really stuck on a problem and how you solved it?
what are several options for creating reports in web report studio? : Sas-bi
what is sas business intelligence? : Sas-bi
List out some key concept of SAS
How can you limit the variables written to output dataset in data step?
What are the uses of sas?
