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 is business intelligence? : Sas-bi
What is the difference between %put and symbolgen? : sas-macro
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....?
Difference between sum function and using “+” operator?
What is maximum number of rows and cols can be handled in SAS?
what are methods to identify duplicate observations?
What is the order of application for output data set options, input data set options and SAS statements?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
Why do we use QUIT commmand for proc datasets and proc sql ???
what are input dataset and output dataset options?
What are the limitations for memory allocation for SAS variables