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 are the statements that are executed only?
What is the use of divide function?
explain the key concept of sas? : Sas-administrator
What commands are used in the case of including or excluding any specific variables in the data set?
If a variable contains only numbers, can it be a character data type?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
what is hierarchy flattening? : Sas-di
Explain what is the use of proc gplot?
Difference between nodup and nodupkey options?
AE datasets names? how many types?
Explain substr function?
what are some differences between proc summary and proc means? : Sas programming
how do the in= variables improve the capability of a merge? : Sas programming
What’s the difference between var b1 – b3 and var b1 — b3?