what is syntax of proc merge ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
What are the different types of sas functions?
What commands are used in the case of including or excluding any specific variables in the data set?
What are the statements in proc sql?
what is snowflake schema? : Sas-di
what are the considerations when picking a SAS/STAT procedure?
0 Answers Accenture, Quintiles,
Tell e how how dealt with..
What is univariate n where it can be used n how...?
How do you use the do loop if you don’t know how many times you should execute the do loop?
what is OLAP?
Explain proc univariate?
What statement do you code to tell SAS that it is to write to an external file?
What are the data types does SAS contain?