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 |
Code a PROC MEANS that shows both summed and averaged output of the data.
What is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
Under what circumstances would you code a SELECT construct instead of IF statements?
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?
Which statement does not perform automatic conversions in comparisons?
what is the function of catx syntax? : Sas-administrator
What are SAS/ACCESS and SAS/CONNECT?
What is the basic syntax style in SAS?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
explain the difference between proc means and proc summary?
What is the use of divide function?