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
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 |
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 |
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 |
what is treatment emergent events and treatment emregent adverse event
Describe crosslist option in tables statement?
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
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?
what is star schema? : Sas-di
What is the use of divide function?
describe about joins? briefly?
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?
What SAS statements would you code to read an external raw data file to a DATA step?
how do you want missing values handled? : Sas programming
What is the Program Data Vector (PDV)? What are its functions?
what are the sites did u refer for enquiries and doubts for SAS