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 |
if we dont want to print output what we have to do..???give syntax..???
8 Answers Accenture, GSK GlaxoSmithKline,
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
in ods is there any lib's
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
State the difference between INFORMAT and FORMAT ?
How to create an external dataset with sas code?
What is the difference between input and infile statement?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
how do you validate sas program?
What SAS statements would you code to read an external raw data file to a DATA step?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
how does sas handle missing values in functions? : Sas programming