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
If a variable contains letters or special characters, can it be numeric data type?
Differences between where and if statement?
Describe 5 ways to do a “table lookup” in SAS?
Why double trailing @@ is used in input statement?
explain about sas business intelligence? : Sas-bi
Explain the purpose of retain statement.
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?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What is the difference between one to one merge and match merge? Give an example.
What are the 3 components in sas programming?
Can you execute a macro within a macro? Describe. : sas-macro
Explain the special input delimiters used in sas programming.
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
explain the concepts and capabilities of business object? : Sas-bi
What is the function of output statement in a SAS Program?