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
Describe the ways in which you can create macro variables?
List out some key concept of SAS
what are validation tools that are used in sas? : Sas-administrator
State the difference between INFORMAT and FORMAT ?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
what is study design in while working with SAS? what are screening variables in SAS?
What are the different types of sas functions?
Differentiate between ceil and floor functions.
What is the difference between SAS functions and procedures?
How do you delete duplicate observations in sas?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
Did you used proc test? when?
explain the use of % includes a statement in sas? : Sas-administrator
for report generation which one you used proc report or data_null_?