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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
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
describe about joins? briefly?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: describe about joins? briefly?
Answer
# 1
we can use the set and merge commands to join the datas,use
merge if u like to joining data tables that has similar
observation  and diff observation and relatted variable mean
use SET ,V can also use proc sql joing the data tables ,i am
beginner on sas so if any one have differ with my ans just
post to my mail kumarravi111@gmail.com
 
Is This Answer Correct ?    3 Yes 1 No
Rrrrrrr
 
  Re: describe about joins? briefly?
Answer
# 2
Use proc sql for joins,

There are 5 types of joins in sas

1) Inner Join :- Output would be only matched cases.

2) left outer Join :- Output would be all the rows from 
left table with corresponding matched value from right 
table.

3) right Join :- vice versa of left Join.

4) Full outer join :- will take all matched & unmatched 
rows of both the tables.

5) Product Join :- this will join the 2 tables without any 
common variable.
 
Is This Answer Correct ?    1 Yes 0 No
Hardeep Malhotra
 
 
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
What is _n_? Accenture18
sas implimented companies in hyderabad CTS4
How do you write a test plan? Oracle1
What is LAG function?How is it used? can any one explain Verinon-Technology-Solutions2
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other? Oracle4
Do you prefer Proc Report or Proc Tabulate? Why? Oracle6
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?  1
How do you add a number to a macro variable?  2
How to select the observations randomly from a SAS dataset  4
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter? Accenture2
if x=round(26.3,10)-1 then x= how much and how explain? BoA2
How would you determine how far down on a page you have printed in order to print out footnotes?  3
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.  3
how do we mail reports from SAS environment to our team leader Wockhardt4
Do you think professionally? Oracle1
Can you excute a macro within a macro? Describe.  2
What is the pound sign used for the DATA _NULL_?  8
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?  2
what is SAS/Access and SAS/Connect?what are the uses?  2
How do you add a number to a macro variable?  1
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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