ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Data Warehouse >> SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (836)
 Informatica interview questions  Informatica Interview Questions (1617)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
Question
what is Difference between PROC SQL JOINS and MERGE?
 Question Submitted By :: Sankar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is Difference between PROC SQL JOINS and MERGE?
Answer
# 1
The resultant dataset depends on the input datasets.
In case of one to one and one to many both work
similarly,i.e. the resultant dataset is same.
But differs in case of many to many and non matching
datasets:
many to many:
ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
1 C 1 R ---> 1 C R 1 A R
2 B 2 G 2 B G 1 C F
1 C R
2 B G


NON MATCHING DATA:

ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
2 B 3 T ---> 2 B . 3 C T
3 C 4 G 3 C T
4 . G
 
Is This Answer Correct ?    28 Yes 6 No
Rajitha Macherla
 
  Re: what is Difference between PROC SQL JOINS and MERGE?
Answer
# 2
merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!
 
Is This Answer Correct ?    0 Yes 9 No
Nrtya Vardhanapu
 
 
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
What is Transaction...? And what are Comment, Roll back n Save point..?   2
Hot to suppress characters from a given string? CTS 4
What are the criticality that you have faced during your project in SAS?   2
What does error:1 mean? Accenture 6
what is option year cuttoff in sas L&T 2
how can get the first and last observations in a dataset using Proc SQl? Satyam 3
what is the difference btw proc means and proc univariate? HSBC 7
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS? Accenture 1
How could you generate test data with no input data?   11
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?   5
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT D&B 8
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?   2
 
For more SAS Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com