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
Mention sas system options to debug sas macros.
What is SAS? What are the functions does it performs?
what is the difference between unique key and primary key? : Sas-di
is data integration and etl programming is same? : Sas-di
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Mention some common errors that are usually committed in sas programming.
Did you used proc test? when?
Differentiate between sas functions and sas procedures.
What was the last computer book you purchased? Why?
What are the default statistics that proc means produce?
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
which features do you use to check the data validations and errors? : Sas-administrator
How do you control the number of observations and/or variables read or written?
Difference between SAS STATA & SPSS?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming