what is syntax of proc merge ?

Answer Posted / neel

proc sort data=ds1;
by var1;
proc sort data=ds2;
by var1;
run;

*from both datasets only matching data;
data match_merge;
merge ds1(in=a) ds2(in=b);
by var1;
if a and b;
run;

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the purpose of retain statement.

613


what is data governance? : Sas-di

631


what is the function of catx syntax? : Sas-administrator

662


How do dates work in SAS data?

697


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

585






what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

741


What is the difference between where and if statement?

630


Can you suggest us materials for sdtm mapping?

4047


Briefly explain input and put function?

642


What is a put statement?

671


What is the basic syntax of a sas program?

675


what are the component of range? : Sas-bi

629


how does sas handle missing values in procs? : Sas programming

643


what techniques and/or procs do you use for tables? : Sas programming

584


What is the difference between %put and symbolgen? : sas-macro

684