what is the difference between SET and MERGE?
Answer Posted / srinivas,korasavada
set concatinate the data set and of the another data
set.The second dataset starts end of the last value onwards.
merge:It adds sas files one dataset to end of the another
dataset.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
describe how to adjust the performance of data integrator? : Sas-di
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 Proc glm does?
What is the difference between using drop = data set option in data statement and set statement?
What is SAS? What are the functions does it performs?
what are some good sas programming practices for processing very large data sets? : Sas programming
Explain the use of proc print and proc contents?
do you need to know if there are any missing values? : Sas programming
Why double trailing @@ is used in input statement?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What are symget and symput? : sas-macro
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Have you used macros? For what purpose you have used? : sas-macro
Explain how you can debug and test your SAS program?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?