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
- 7079 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 cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What areas of SAS are you most interested in?
what is business intelligence? : Sas-bi
Can you execute a macro within a macro? Describe. : sas-macro
How to limit decimal places for the variable using proc means?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what are the best practices to process the large data sets in sas programming? : Sas-administrator
How to create list output for cross-tabulations in proc freq?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is the difference between one to one merge and match merge? Give an example.
If a variable contains letters or special characters, can it be numeric data type?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
How are numeric and character missing values represented internally?
What are the differences between proc means and proc summary?
In sas, what are the areas that you are most interested in? : sas-grid-administration
