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
how do you debug and test your sas programs? : Sas programming
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
how does sas handle missing values in functions? : Sas programming
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
Why and when do you use proc sql?
What is the difference between the proc sql and data step?
In ARRAY processing, what does the DIM function do?
What is the role of unrestrictive users? : sas-grid-administration
what are validation tools that are used in sas? : Sas-administrator
Explain input and put function?
Enlist the syntax rules followed in sas statements.
Explain how merging helps to combine data sets.
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is the difference between infile and input? : Sas-administrator
how to remove duplicates using proc sql?