Diff between proc sql merge and join?
- 1 Answers
- 3543 Views
- HSBC, Sristek, I also Faced
- E-Mail Answers
Answer / anand
Merge - Data sets must be sorted by or indexed on the BY variable prior to merging.
Proc SQL - Data sets doesnot need to be sorted or indexed.
| Is This Answer Correct ? | 8 Yes | 0 No |
Explain the use of proc print and proc contents?
What is the length assigned to the target variable by the scan function?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what is the use of LRECL option.
What does the trace option do?
How to sort in descending order?
how does sas handle missing values in functions? : Sas programming
How would you define the end of a macro?
Are you sensitive to code walk-throughs peer review or QC review?
what is intially documentation in sas?
What is highest missing value for numeric?
How do you control the number of observations and/or variables read or written?
Teradata 
