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 / 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 basic structure of the SAS base program?
how do the in= variables improve the capability of a merge? : Sas programming
How many data types are there in SAS?
how sas deals with business intelligence? : Sas-bi
How do you control the number of observations and/or variables read or written?
what is sas database server? : Sas-di
how can you create zero observation dataset? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
What are the features of SAS?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is your favorite all time computer book? Why?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?