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
- 7053 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 |
how to know the attributes of first five datasets in a library
what is the formula to measure Baseline
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
What are the different versions of sas that you have used until now? : sas-grid-administration
Which is the best training Institute for SAS Business Intelligence course?
What is the basic syntax style in SAS?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Do you need to know if there are any missing values?
How do you read in the variables that you need?
What is a macro routine?
in ods is there any lib's
what are scrubing procedures in SAS?
Teradata 
