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
- 7348 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
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is the difference between one to one merge and match merge? Give an example.
What do you know about sas and what we do? : sas-grid-administration
Approximately what date is represented by the SAS date value of 730?
why is sas data integration studio important? : Sas-di
what are some good sas programming practices for processing very large data sets? : Sas programming
What do you code to create a macro? : sas-macro
Are you involved in writing the inferential analysis plan? Tables specfications?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Describe the function and untility of the most difficult SAS macro that you have written.
Tell e how how dealt with..
Are you sensitive to code walk-throughs peer review or QC review?
Give e an example of..
What is factor analysis?
What is maximum number of rows and cols can be handled in SAS?
