Diff between proc sql merge and join?
- 1 Answers
- 3511 Views
- HSBC, Sristek, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
for report generation which one you used proc report or data_null_?
Explain bmdp procedure?
what is factor analysis? : Sas-administrator
What is the order of application for output data set options, input data set options and SAS statements?
Name and describe few sas character functions that are used for data cleaning in brief.
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
how do you test for missing values? : Sas programming
Are you sensitive to code walk-throughs peer review or QC review?
How would you invoke a macro? : sas-macro
describe about physical data integration? : Sas-di
What is SAS? What are the functions does it performs?
Explain the difference between nodup and nodupkey options?
What is the difference between one to one merge and match merge? Give an example.
For what purposes have you used sas macros? : sas-macro
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
