Do you need to combine data sets? How should you combine data sets

Do you need to combine data sets? How should you combine
data sets– MERGE or SET statements in DATA steps,PROC
APPEND,PROC SQL?

Question Posted / jaya

3 Answers
7026 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DA..

Answer / ankit

it is depend upon my needs how to join these data set if we want to join data vertically then use set otherwise for horizontal i'll use merge.

Is This Answer Correct ?

4 Yes

0 No

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DA..

Answer / charan araveti

Append/Set:
If you want to Add/Append data to Existed/Newly created
Dataset (With same variabls)

EX: you have DATA SETS Like JAN,FEB,MAR........,DEC.
and you want to create data set like "Sales_2010"
you have to use "SET/APPEND" Statements.

MERGE:
If you want add Existed variables to DataSet you have to use
Merge.
EX: If you 2 Dtasets of one person like Personal &
Professional and you want to all details in one dataset
means you have to use "Merge" with 'BY' Statement.

Is This Answer Correct ?

4 Yes

0 No

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DA..

Answer / vimal

proc append is best to just combine two datasets.
it appends in bulk and without have to read and send to output. it just puts the dataset in data= to dataset in base=

Is This Answer Correct ?

0 Yes

0 No

Post New Answer