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 ?
Answer Posted / santhosh
worng
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
what is study design in while working with SAS? what are screening variables in SAS?
Describe a time when you were really stuck on a problem and how you solved it?
What is the role of unrestrictive users? : sas-grid-administration
What is the use of stop statement?
Name few SAS functions?
What’s the difference between var b1 – b3 and var b1 — b3?
what is sas database server? : Sas-di
In ARRAY processing, what does the DIM function do?
Mention how to limit decimal places for the variable using proc means?
What is program data vector (pdv)?
Difference between SAS STATA & SPSS?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what does the run statement do? : Sas programming
what do you mean by data staging area? : Sas-di
what is the function of catx syntax? : Sas-administrator