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 are numeric and character missing values represented internally? : Sas programming
how to change the execute of macro
explain about data integrator metadata reports? : Sas-di
What does P-value signify about the statistical data?
What can be the size of largest dataset in SAS?
Tell me more about the parameters in macro? : sas-macro
What are the statements in proc sql?
What is the difference between %put and symbolgen? : sas-macro
how do you pull data from equifax?tell me the process?
What are the special input delimiters used in SAS?
What is the difference between reading data from an external file and reading data from an existing data set?
Differentiate input and infile.
Enlist the functions performed by sas.
: and & modifiers.
Explain data step in SAS