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
- 7199 Views
- I also Faced
- E-Mail Answers
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 the sas data set? : sas-grid-administration
how to generate means for every subject;
What is the function of Stop statement in a SAS Program?
How to merge the data using merge statement and proc format? Is the result is same ?
Name any two sas spawners? : sas-grid-administration
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
How to convert .xls file into CSV format?
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
How to create an external dataset with sas code?
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
What are the table names in oracle database...?
Teradata 
