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
define table lookup and how may ways it can be 
done...explian
 Question Submitted By :: Aravind Rangaraj
I also faced this Question!!     Rank Answer Posted By  
 
  Re: define table lookup and how may ways it can be done...explian
Answer
# 1
I guess lot of ways, but I cna quickly think of two.

1. Create format with code and values, Put the formats in a 
catalog and set option for fmtsearch and apply format to 
teh variable.

2. Create temp dataset with input data in datastep. And use 
proc SQL to join or use DATA step merge.
 
Is This Answer Correct ?    0 Yes 0 No
Rc
 
  Re: define table lookup and how may ways it can be done...explian
Answer
# 2
Table lookup is a process of retriving information from
second dataset and add to first data set. different ways to
do look up.
1. data step with merge function.
2. set statement and Key option.
3. Proc sql into clause, inner join, subquery
4. proc format 5. conditional logics if, where, update
statements. 6. arrays with do loops 7. update statement.
 
Is This Answer Correct ?    0 Yes 0 No
Vijaya Mekala
 
 
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
What is the purpose of using the N=PS option? Oracle1
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?  3
In the flow of DATA step processing, what is the first action in a typical DATA Step? Accenture5
How would you delete duplicate observations?  7
What is the order of evaluation of the comparison operators: + - * /** ()?  2
What is the difference between verification and validation? Oracle4
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this? Xansa4
what is the need of INDEX in datasets? CitiGroup3
Under what circumstances would you code a SELECT construct instead of IF statements? Accenture4
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 the difference between compiler and interpreter? give any one example (software product) that act as a interpreter? Accenture3
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?  3
What techniques and/or PROCs do you use for tables? Oracle3
how can you code the confidence intervals? Ranbaxy3
Name statements that function at both compile and execution time. L&T1
What is _n_? Accenture18
Do you prefer Proc Report or Proc Tabulate? Why? Oracle6
wt is a-z and a--z? Accenture1
what is Global Symbol table and Local symbol table? CitiGroup2
At compile time when a SAS data set is read, what items are created? Accenture8
 
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