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
what do the pad and dim functions do? : Sas programming
What are the 3 components in sas programming?
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the good sas programming practices for processing large data sets?
What do the SAS log messages "numeric values have been converted to character" mean?
How would you include common or reuse to be processed along with your statements?
What is a put statement?
explain about various caches available in data integrator? : Sas-di
Explain the difference between informat and format with an example.
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
Explain translate function?
What is the difference between reading data from an external file and reading data from an existing data set?
How do dates work in SAS data?
How can you create a macro variable with in data step? : sas-macro
What are the data types does SAS contain?
