:: 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                      
Categories >> Software >> Data Warehouse >> SAS


 Teradata interview questions  Teradata Interview Questions (184)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 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 (172)
 Data Stage interview questions  Data Stage Interview Questions (565)
 SAS interview questions  SAS Interview Questions (561)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
what is Difference between PROC SQL JOINS and MERGE?
 Question Submitted By :: SAS
I also faced this Question!!     Answer Posted By  
# 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
many to many:
ex: (merge on x) (proc sql)
----- ------ ------- -------
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


ex: (merge on x) (proc sql)
----- ------ ------- -------
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
# 2
Before doing the merge process we have to do sorting depended the key variable, but in proc sql joins no need to do sorting. 
Is This Answer Correct ?    2 Yes 0 No
# 3
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
in data set200 observation how to take 110,150,170 using sql procedure? Accenture 6
What is difference between (a-z) and (a--z) Accenture 6
who is the best SAS clinical Trainer in Hyderabad?   1
what are the different ways of merging two atleast 4.   2
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.   2
how many types of MERGE? CitiGroup 17
tell me about intnx, intcx functions? CitiGroup 4
How do handle working under pressure? Oracle 1
What techniques and/or PROCs do you use for tables? Oracle 4
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output can we do this one? GSK 6
Under what circumstances would you code a SELECT construct instead of IF statements?   4
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 HSBC 3
For more SAS Interview Questions Click Here 

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