Interested to Buy Any Domain ? << Click Here >> for more details...
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
name several ways to achieve efficiency in your program? : Sas programming
What is the purpose of trailing @ and @@? How do you use them?
Do you know the features of sas?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Explain proc sort?
Explain the use of proc print and proc contents?
how to remove duplicates using proc sql?
For what purposes have you used sas macros? : sas-macro
what is star schema? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
How you can read the variables that you need?
What areas of SAS are you most interested in?
how could you generate test data with no input data? : Sas programming
Explain the difference between nodup and nodupkey options?
What is Linear Regression?
