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


Please Help Members By Posting Answers For Below Questions

Which command is used to perform sorting in sas program?

599


What is the order of application for output data set options, input data set options and SAS statements?

1085


which date functions advances a date time or date/time value by a given interval? : Sas programming

540


Give e an example of..

1847


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1777






i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

1975


Mention what are the data types does SAS contain?

699


Give some examples where proc report’s defaults are different than proc print’s defaults?

601


What is the maximum and minimum length of macro variable

657


Which statement does not perform automatic conversions in comparisons?

1205


what does the run statement do? : Sas programming

558


How does proc sql work?

618


What do you understand by the term Normal Distribution?

570


What is the basic structure of a sas program?

602


Of all your work, where have you been the most successful?

4205