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
explain the difference between proc means and proc summary?
What will calendar procedure do?
where to use sas business intelligence? : Sas-bi
Explain why double trailing @@ is used in input statement?
How would you include common or reuse to be processed along with your statements?
How do you debug and test your SAS programs?
Mention common programming errors committed in sas ?
What is the maximum and minimum length of macro variable
What is the purpose of _character_ and _numeric_?
What is the difference between using drop = data set option in data statement and set statement?
What are the new features included in the new version of SAS Programming Language?
Explain the use of proc gplot? : sas-grid-administration
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
how does sas handle missing values in formats? : Sas programming
what is sas and what are the functions? : Sas-administrator
