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

how does sas handle missing values in sort order? : Sas programming

527


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

533


What is the difference between proportion and average?

2753


What does PROC print, and PROC contents do?

722


what is the effect of the options statement errors=1? : Sas programming

588






How does the internal authentication work in sas? : sas-grid-administration

581


Enlist the functions performed by sas.

673


what is the basic structure sas administrator? : Sas-administrator

563


How would you identify a macro variable? : sas-macro

528


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

593


What are the automatic variables for macro? : sas-macro

672


Explain the main difference between the sas procedures and functions? : Sas-administrator

534


how do you debug and test your sas programs? : Sas programming

558


what is hierarchy flattening? : Sas-di

616


Explain by-group processing?

587