Do you need to combine data sets? How should you combine
data sets– MERGE or SET statements in DATA steps,PROC
APPEND,PROC SQL?
Answer Posted / 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 |
Post New Answer View All Answers
for whom is sas data integration studio designed? : Sas-di
How to include or exclude specific variables in a data set?
What are common programming errors committed in sas
what is snowflake schema? : Sas-di
Explain translate function?
What versions of SAS have you used (on which platforms)?
Name few SAS functions?
State the difference between INFORMAT and FORMAT ?
what other sas products have you used and consider yourself proficient in using? : Sas programming
Explain data_null_?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Explain the main difference between the sas procedures and functions? : Sas-administrator
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What are the five ways to do a table lookup in sas? : sas-grid-administration
name the scheduler for scheduling job and explain the scheduler? : Sas-di