what is syntax of proc merge ?

Answers were Sorted based on User's Feedback



what is syntax of proc merge ?..

Answer / marlene

There is no PROC MERGE. You can use a merge statement as
part of the data step.

Is This Answer Correct ?    46 Yes 6 No

what is syntax of proc merge ?..

Answer / mahesh goud.e

according to my knowledge there is no any syntax of proc
merge in sas. but merge statement statement of data step.

Is This Answer Correct ?    14 Yes 0 No

what is syntax of proc merge ?..

Answer / mahesh

data dsn;
merge dsn1 dsn2;
by vari;
run;

Is This Answer Correct ?    17 Yes 5 No

what is syntax of proc merge ?..

Answer / 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

what is syntax of proc merge ?..

Answer / krishna

there is no proc merge
we can do by dataset block
syntax:
proc sort data=<dataset name>;
by <var>;
run;

data ab;
merge a b;
run;

Is This Answer Correct ?    3 Yes 1 No

what is syntax of proc merge ?..

Answer / naveen

proc merge syntex, which is
use to combind data set,

data xyz;
merge a(in=x) b(in=y);
if a x and y;
run;

Is This Answer Correct ?    1 Yes 0 No

what is syntax of proc merge ?..

Answer / sowjanya

data one;
merge three(in=var1) two(in=var2);
by var;
if var1=1 and var2=1;
run;

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SAS Interview Questions

In PROC PRINT, can you print only variables that begin with the letter “A”?

8 Answers  


What is SAS? What are the functions does it performs?

0 Answers  


what is star schema? : Sas-di

0 Answers  


How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?

5 Answers  


I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  


1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question

8 Answers   CitiGroup,


sas macros

12 Answers   TCS,


Have you ever used the SAS Debugger?

0 Answers   Quintiles,


Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  


What are the functions used for character handling?

0 Answers  


Describe how you would pass data to macro.

3 Answers  


what is the difference between the SAS v8 and SAS v9?

7 Answers   TCS,


Categories