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 are types of transport files?
If a variable contains only numbers, can it be a character data type?
Did you used proc test? when?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
what is sas metadata server? : Sas-di
Name validation tools used in SAS
What is the difference between input and infile statement?
How will you generate test data with no input data?
What is a method to debug and test your SAS program?
what is business intelligence? : Sas-bi
what is sas data set?
What is the maximum length of the macro variable?
I need level 2 to 5 sas using companies in india
how does sas handle missing values in assignment statements? : Sas programming
What is substr function?
