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

what is business intelligence? : Sas-bi

0 Answers  


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

0 Answers  


Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  


Difference between sum function and using “+” operator?

0 Answers  


What is maximum number of rows and cols can be handled in SAS?

0 Answers   Signetsoft,






what are methods to identify duplicate observations?

5 Answers   HCL,


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

0 Answers   Quintiles,


I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  


How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 Answers  


Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  


what are input dataset and output dataset options?

6 Answers   HCL,


What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,


Categories