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 |
Which of the following is not created during compilation phase?
How do you use the do loop if you don’t know how many times you should execute the do loop?
If a variable contains only numbers, can it be a character data type?
what is in stream data in SAS?
how to generate the test data in sas without input data? : Sas-administrator
How do you debug macros?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Which is the best training institute for SAS in Delhi. Please reply
If money were no object, what would you like to do?
At compile time when a SAS data set is read, what items are created?
Explain how merging helps to combine data sets.
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated