Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

More SAS Interview Questions

what is treatment emergent events and treatment emregent adverse event

0 Answers  


Describe crosslist option in tables statement?

0 Answers  


We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  


i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,


what is star schema? : Sas-di

0 Answers  


What is the use of divide function?

0 Answers  


describe about joins? briefly?

2 Answers   CitiGroup,


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  


What SAS statements would you code to read an external raw data file to a DATA step?

6 Answers   Accenture,


how do you want missing values handled? : Sas programming

0 Answers  


What is the Program Data Vector (PDV)? What are its functions?

5 Answers   Accenture,


what are the sites did u refer for enquiries and doubts for SAS

2 Answers   UBS,


Categories