Answer / vij

Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:

Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement:

Answer / vij/vijji

Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:

Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement

Answer / pricil kurian

Types of merges:-
1)one to one merge- It is the merge without any by variables
2)Match merges- Where we are using by variables.
Under match merge we have 1-1 , 1-many, and many-many
depending on the values in by variables.
For many-many merge proc sql will be relaiable.
Please correct me if I am wrong.

Answer / srinivas

Source:SAS

Link :
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a002645445.htm

SAS provides several different methods for combining SAS
data sets. In this section, you will be introduced to five
methods of combining data sets:
1)concatenating
2)interleaving
3)merging
4)updating
5)modifying

When it comes to Merging,there are two types:

1)One-to-one merging
2)Match merging
Thanks!

Answer / mr.s

according to the question ,there are 2 types of merging.they
are "one-one merge" &"one -many merging" there's no need of
nay deviation to the answer ok

Answer / name is no need

Arai Name Is No Need , i think you dont know anything, you
stupid try to encourage them or otherwise keep quiet , if
abuse anybody then definitely i can you . you idiot
...................................

Answer / sakshi

there are three types of merging:
one to one
may to one or one to many
no match merge

Answer / mallikarjuna reddy.vanna

4 types of merges are present.
they are
1.one to one merging
2.one to many
3.many to one
4.many to many

Answer / kishore

total 3 types of mergings are available
they are one to one merging, one to many merging, many to
many merging

Answer / srilatha

the types of merge are
1) one to one merging
2) match merging

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers  

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

3 Answers   Accenture, Novartis,

Differences between where and if statement?

1 Answers  

what are the sites did u refer for enquiries and doubts for SAS

2 Answers   UBS,

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 Answers  

How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

how to read the variables in sas? : Sas-administrator

1 Answers  

Explain the use of proc gplot? : sas-grid-administration

1 Answers  

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.

1 Answers  

what is difference in window SAS & Unix SAS.....how do define working environment in both???

1 Answers   JPMorgan Chase,

What is the use of divide function?

1 Answers  

What are the statements that are executed only?

1 Answers