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
- 10484 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 reading data from an external file and reading data from an existing data set?
what other sas products have you used and consider yourself proficient in using? : Sas programming
How would you identify a macro variable? : sas-macro
do you need to know if there are any missing values? : Sas programming
how does sas handle missing values in formats? : Sas programming
what do you mean by data staging area? : Sas-di
name some data transformation used in sas di? : Sas-di
How does the internal authentication work in sas? : sas-grid-administration
What are the difference between ceil and floor functions in sas?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Difference between informat and format?
How do you delete duplicate observations in sas?
What are the functions used for character handling?
What function CATX syntax does?
