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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 to write code for left outer join in SAs using datastep?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to write code for left outer join in SAs using datastep?
Answer
# 1
Data Left_outer;
set data1(in=x) data2(in=y);
if x=0 and y=1;
run;
 
Is This Answer Correct ?    0 Yes 0 No
Vk
 
  Re: how to write code for left outer join in SAs using datastep?
Answer
# 2
dnt use set it wnt work.
use merge with in statements as above.
 
Is This Answer Correct ?    1 Yes 0 No
Jbhjhj
 
 
 
  Re: how to write code for left outer join in SAs using datastep?
Answer
# 3
There is no such Inner & Left Joins.  In SAS only one join 
i.e Right Join.  If you want Left Join you have to use the 
data set in the second place. For example: D1 D2 are the 
data sets for D2 you want to make, UPDATE D1 D2;
 
Is This Answer Correct ?    0 Yes 1 No
Pnprasad
 
  Re: how to write code for left outer join in SAs using datastep?
Answer
# 4
Data left_outer;
merge emp(in=a) dept(in=b);
by deptno;
if a=1 and b=0;
run;
 
Is This Answer Correct ?    1 Yes 0 No
Aniruddha
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
how can you code the confidence intervals? Ranbaxy3
SAS System ?  2
how to assign a macro value to a variable? CitiGroup3
What do you feel about hardcoding? Oracle4
Name statements that are execution only?  6
Name the option to produce a frequency line items rather that a table.  1
what is Global Symbol table and Local symbol table? CitiGroup2
Which date functions advances a date time or date/time value by agiven interval?  1
What is the Program Data Vector (PDV) and What are its functions?  9
What is _n_?  17
Under what circumstances would you code a SELECT construct instead of IF statements?  3
What does a PROC TRANSPOSE do? Accenture2
Describe how you would pass data to macro.  3
tell me about intnx, intcx functions? CitiGroup2
wat is sas? is a package or programming language?  2
what is portability of sas programmes? Capital-One1
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question CitiGroup8
how we can call macros with in data step? Allianz11
Briefly describe 5 ways to do a "table lookup" in sas.  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