what is Difference between PROC SQL JOINS and MERGE?
Answer Posted / nrtya vardhanapu
merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!
| Is This Answer Correct ? | 0 Yes | 13 No |
Post New Answer View All Answers
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Mention few capabilities of sas framework.
For clinical entire study how many tables will create approx?
List down the reasons for choosing sas over other data analytics tools.
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What are symget and symput? : sas-macro
what are all the reports you generated in your recent project?
What is the difference between one to one merge and match merge? Give an example.
how would you determine the number of missing or nonmissing values in computations? : Sas programming
How long can a macro variable be? A token? : sas-macro
What is the difference between %put and symbolgen? : sas-macro
why is sas considered self-documenting? : Sas programming
What do you code to create a macro? : sas-macro
Explain what is data step?