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 many types prompting framework can be broken down to? : Sas-bi
Are you involved in writing the inferential analysis plan? Tables specfications?
what is sas olap server? : Sas-di
What can you learn from the SAS log when debugging?
How you can read the variables that you need?
what is study design in while working with SAS? what are screening variables in SAS?
what is sas business intelligence? : Sas-bi
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is SAS OPTIMIZATION?
What does the trace option do?
Differentiate between proc means and proc summary.
What is the role of sas grid administrator? : sas-grid-administration
what are sas bi dashboard components? : Sas-bi
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Explain data_null_?