what is the difference between SET and MERGE?
Answers were Sorted based on User's Feedback
Answer / lavanya
the difference between set and merge is
set concatenates the data sets where as merge matches the
observations of the data sets.
Is This Answer Correct ? | 62 Yes | 4 No |
Answer / mallikarjuna reddy
set statement joins two datasets vertically, like set
operators in PROC SQL and proc append. merge statements
joins 2 datasets horizontally, like joins in PROC SQL.
Is This Answer Correct ? | 34 Yes | 7 No |
Answer / swetha
We use merge when we have information abouth the topic in
two or more datasets. So that by merging we get the
complete information about the topic in one dataset.It is
combining the data horizontally.
But we use set, when the datasets are mutually exclusive.
i.e. information in dataset A in not depending the
information in dataset B.It is combining the data
vertically.
Is This Answer Correct ? | 24 Yes | 0 No |
Answer / ram
Set: Arrange the data one by one
merge: Arrange the data side by side
ex: set merge
id name age id name age
1 1 a 23
a
23
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / pratik
Set statments are used to copy the data from existing
database to new database.
where merge is used to join two dataset and both should
have common varaible and same number of observation.
IN mearging we have two type one is
Vertically-we have three process concate,interleaving and
append.
in concate and interleaving we use set option.
Horazentally-we use Merge option.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / ram
Methods of Combining Sas Datasets: Concatenation(set statment), Merge Statement:
Concatenating combines two or more SAS data sets, one after the other, into a single SAS data set.
- Use the SET statement in a DATA step to concatenate SAS data sets.
- Any number of SAS data sets can be read with a single SET statement.
Merging combines observations from two or more SAS data sets into a single observation in a new data set.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kithsiri
Data C;
Set A B;
run;
Concaternate A and B data sets and make c Data set. Then data of B data set is placed after data of A data set. If A has n1 number of observation and B set has n2 number of observation. Then C(new set has n1+n2 number of data)
Data C;
set A B;
By var1;
run;
If var1 variable is exist in both A and B data sets, in C data set rows are arrenged according to var1 variable(ascending order).
Data C;
merge A B;
By var1;
run;
Data are arrenged side by side if there are var1 in both data sets and match rows of both sets. If A data set is not matched with B then display records of A in left side and right side data is missing values. If B data is not matched with A then display records of B in right side and left side data is missing values. If there is same variable in both tables, observation of that variable of first table is replaced by observation of the same variable of second table when match observation of var1 in both tables.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prabhakar
Set statement reads observations from one or more sas data set.
Merge statement joins two or more sas data sets into singe observations.
(or)
Set statement reads observations from one sas data sets at a time and joins into one data set.
Merge statement reads observations from one or more sas data sets simultaneously and joins into one data set.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pricil kurian
Practically adding different information to same records is
known as merging. While Adding same information to new
records is known as set.
Is This Answer Correct ? | 2 Yes | 1 No |
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
. Which date advances a date, time or date/time value by a given interval?
explain the difference between proc means and proc summary?
What is difference between (a-z) and (a--z)
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How to select the observations randomly from a SAS dataset
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
Describe 5 ways to do a “table lookup” in SAS?
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
Mention what is SAS data set?