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
- 7179 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 chi-square test? have you used that?
1 Answers Accenture, Quintiles,
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
why is a stop statement needed for the point=option on a set statement? : Sas programming
How do you add a number to a macro variable?
What SAS statements would you code to read an external raw data file to a DATA step?
what are different type of sas servers ? On which server does the sas code execute ?
what is difference in window SAS & Unix SAS.....how do define working environment in both???
Can anyone help me about SAS Realtime scenarios in Clinical field
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
what are the differences between proc report and proc tabulate?
what type of graphs we will create(for 2+years candidates)?
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
Teradata 
