Answer Posted / nishant
PROC SQL is a powerful tool in sas which combines the
functionality of data and proc steps. PROC SQL can sort,
summarize, subset, join (merge), and concatenate datasets,
create new variables, and print the results
or create a new dataset all in one step!
PROC SQL uses less resources when compared to that of data
and proc steps.
To join files in PROC SQL it does not require to sort the
data prior to merging which is must is data merge
| Is This Answer Correct ? | 22 Yes | 1 No |
Post New Answer View All Answers
how to do user inputs and command line arguments in sas?
How do you test for missing values?
Are you involved in writing the inferential analysis plan? Tables specfications?
Differentiate between ceil and floor functions.
Difference between sum function and using “+” operator?
Explain how merging helps to combine data sets.
what is business intelligence? : Sas-bi
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
why is a stop statement needed for the point=option on a set statement? : Sas programming
Do you know the features of sas?
explain about sas business intelligence? : Sas-bi
What does the trace option do?
how sas deals with business intelligence? : Sas-bi
What is proc sort?
Which are the statements whose placement in the data step is critical?