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 ?
- 4 Answers
- 9064 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / santhosh
worng
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is a method to debug and test your SAS program?
What is the difference between reading data from an external file and reading data from an existing data set?
what is intially documentation in sas?
how do you debug and test your sas programs? : Sas programming
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is a macro routine?
How do dates work in sas?
What does PROC print, and PROC contents do?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Mention the validation tools used in SAS?
what is the difference between floor and ceil functions in sas? : Sas-administrator
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
what is the effect of the options statement errors=1? : Sas programming
Enlist the syntax rules followed in sas statements.
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
