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?
- 3 Answers
- 7173 Views
- I also Faced
- E-Mail Answers
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
Did you used proc test? when?
Mention few capabilities of sas framework.
what are informats in sas? : Sas-administrator
What are the five ways to do a table lookup in sas? : sas-grid-administration
What is the difference between reading data from an external file and reading data from an existing data set?
Explain translate function?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
how sas deals with business intelligence? : Sas-bi
What is the purpose of trailing @ and @@? How do you use them?
What is the SAS data set?
Why double trailing @@ is used in input statement?
Mention what is SAS data set?
for what purpose would you use the retain statement? : Sas programming
why is sas considered self-documenting? : Sas programming
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
