How would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set.

Answer Posted / padma

The above proc sql is not working. it is throwing up error.

Please verify. If anybody give proc sql code for the above
question that would be great.

padma

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention sas system options to debug sas macros.

659


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

577


how many display types available in sas bi dashboard? : Sas-bi

636


What sas features do you use to check errors and data validation?

684


How can sas program be validated?

575






What is the basic syntax style in SAS?

612


what is null hypothesis? why do you consider that?

2416


If you could design your ideal job, what would it look like?

2369


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

624


how the sas basic syntax style described? : Sas-administrator

600


Describe the ways in which you can create macro variables?

631


How would you determine the number of missing or nonmissing values in computations?

646


name some data transformation used in sas di? : Sas-di

542


What can be the size of largest dataset in SAS?

713


what are the categories that sas informats are used to the place the data? : Sas-administrator

611