what is the difference between SET and MERGE?
Answer Posted / ram
Methods of Combining Sas Datasets: Concatenation(set statment), Merge Statement:
Concatenating combines two or more SAS data sets, one after the other, into a single SAS data set.
- Use the SET statement in a DATA step to concatenate SAS data sets.
- Any number of SAS data sets can be read with a single SET statement.
Merging combines observations from two or more SAS data sets into a single observation in a new data set.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do you add a number to a macro variable? : sas-macro
How do you use the do loop if you don’t know how many times you should execute the do loop?
Differences between where and if statement?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
What are the data types that sas contain?
name several ways to achieve efficiency in your program? : Sas programming
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What is run-group processing?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What do the PUT and INPUT functions do?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
What is the role of sas grid administrator? : sas-grid-administration
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??