what is syntax of proc merge ?

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

Question Posted / shivakrishna.yenaganti

7 Answers
16114 Views
TCS, I also Faced
E-Mail Answers

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