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 |
How many missing values are available? When might you use them?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is the main difference between rename and label? (don't say that they both perform the same function).
Explain substr function?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
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.
what is sas? is a package or tool? give me introduction about sas?
what are the component of range? : Sas-bi
what is the prob plot in clinical domain
how do u test a pros sql(works or not) without executing it?
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,