what is syntax of proc merge ?

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

More SAS Interview Questions

How many missing values are available? When might you use them?

1 Answers   Quintiles,


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

0 Answers  


what is the main difference between rename and label? (don't say that they both perform the same function).

11 Answers   Parexel,


Explain substr function?

0 Answers  


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

0 Answers   Pfizer,






1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  


what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,


what are the component of range? : Sas-bi

0 Answers  


what is the prob plot in clinical domain

1 Answers   TCS,


how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,


What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers   Accenture, Sciformix,


Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)

3 Answers   Verinon Technology Solutions,


Categories