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 sas olap server? : Sas-di
how do you test for missing values? : Sas programming
what is sas business intelligence? : Sas-bi
what is the primary data source for the wrs? : Sas-bi
What is program data vector (pdv) and what are its functions?
What was the last computer book you purchased? Why?
What is the difference between INPUT and INFILE ?
what is metadata? : Sas-bi
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how could you generate test data with no input data? : Sas programming
What is the difference between input and infile statement?
what is the difference between infile and input? : Sas-administrator
how do you debug and test your sas programs? : Sas programming
explain about various caches available in data integrator? : Sas-di
what do the pad and dim functions do? : Sas programming