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
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What do you know about sas data set?
Which statement does not perform automatic conversions in comparisons?
What does the trace option do?
What are the default statistics that proc means produce?
what are the types of interactive display types? : Sas-bi
What is the basic structure of a sas program?
Give some examples where proc report’s defaults are same as proc print’s defaults?
How would you identify a macro variable?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Describe the ways in which you can create macro variables? : sas-macro
how can you put a "trace" in your program? : Sas programming
what techniques and/or procs do you use for tables? : Sas programming
what has been your most common programming mistake? : Sas programming
Tell e how how dealt with..