define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6739 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijaya mekala
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 ? | 7 Yes | 0 No |
Answer / rc
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 ? | 2 Yes | 0 No |
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is sas metadata repository? : Sas-bi
explain about various caches available in data integrator? : Sas-di
What is the difference Using & and && in the macro variables
Give e an example of..
What other SAS features do you use for error trapping and data validation?
what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';
What is the difference between a PROC step and a DATA step?
Explain how you can debug and test your SAS program?
How do you delete duplicate observations in sas?
What is proc sql pass through facility?
Teradata 
