ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
how many types of MERGE?
 Question Submitted By :: Akshara
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how many types of MERGE?
Answer
# 1
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:
 
Is This Answer Correct ?    1 Yes 0 No
Vij
 
  Re: how many types of MERGE?
Answer
# 2
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
 
Is This Answer Correct ?    0 Yes 0 No
Vij/vijji
 
 
 
  Re: how many types of MERGE?
Answer
# 3
total 3 types of mergings are available
they are  one to one merging, one to many merging, many to
many merging
 
Is This Answer Correct ?    0 Yes 0 No
Kishore
 
  Re: how many types of MERGE?
Answer
# 4
There r four types of merges r there...
match Merge , one to many merge , many to one merge and 
many to many merge
 
Is This Answer Correct ?    0 Yes 0 No
Kishore Kumar
 
  Re: how many types of MERGE?
Answer
# 5
There is 3 types of merge,
1.Equiv Join : Merge the datasets with Only matching   
observations.
2.Non Equiv Join : Merge the datasets with not,greater and 
less matching observations.
3.Outer Join : Merge the datasets with insufficient 
observations.
 
Is This Answer Correct ?    0 Yes 0 No
Ashok Kore
 
  Re: how many types of MERGE?
Answer
# 6
This the Answer u search for - Types of MERGE

1.One to One reading.
2.Concatenating.
3.Interleaving.
4.Mach Merge.

I'll give the Explanation also, If u need.
 
Is This Answer Correct ?    0 Yes 0 No
J.surendhar
 
  Re: how many types of MERGE?
Answer
# 7
7 types 
concatenation
interleving
one to one merge
one to many merge
many to one merge
many to many merge
 
Is This Answer Correct ?    0 Yes 0 No
Siri
 
  Re: how many types of MERGE?
Answer
# 8
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
 
Is This Answer Correct ?    1 Yes 0 No
Mallikarjuna Reddy.vanna
 
  Re: how many types of MERGE?
Answer
# 9
the types of merge are
1)  one to one merging
2)  match merging
 
Is This Answer Correct ?    0 Yes 0 No
Srilatha
 
  Re: how many types of MERGE?
Answer
# 10
arai uselessfelow why are you dropping these type of 
answers.how can a person knows how many types of merges are 
there?
please don't drop the wrong answers.
 
Is This Answer Correct ?    0 Yes 0 No
Name Is No Need
 
  Re: how many types of MERGE?
Answer
# 11
Till now, i had used 2 types of Merges...

1 More than 2 datasets having same BY variable...
eg : Adding summary statistics to the Dataset.
2 More than 2 datasets doesnt having same BY variables...
eg : adding totals to the dataset.
 
Is This Answer Correct ?    0 Yes 0 No
Chandu
 
  Re: how many types of MERGE?
Answer
# 12
hey ashok kore if u know the right answer then post 
otherwise keep quiet(noru musuko) uselessfellow
 
Is This Answer Correct ?    0 Yes 0 No
No Need
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
what is SAS/Access and SAS/Connect?what are the uses?  2
What is the one statement to set the criteria of data that can be coded in any step? Accenture3
what is the use of proc sql? CitiGroup3
How would you code a merge that will keep only the observations that have matches from both sets. Accenture5
what are input dataset and output dataset options? HCL5
At compile time when a SAS data set is read, what items are created? Accenture8
Identify statements whose placement in the DATA step is critical. Accenture4
What is the purpose of using the N=PS option? Oracle1
sas macros  6
How to read multiple excel sheets from a single excel file at once???? Verinon-Technology-Solutions3
How would you determine how far down on a page you have printed in order to print out footnotes?  3
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?  2
how do we get duplicate observations in a separate dataset?  5
how to intersect the tables by using PROC MIXED? CitiGroup1
Which date functions advances a date time or date/time value by agiven interval?  1
what does .. meant in sas macros D&B2
tell me about intnx, intcx functions? CitiGroup2
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values? BoA2
what is portability of sas programmes? Capital-One1
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?  1
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com