define table lookup and how may ways it can be done...explian

define table lookup and how may ways it can be
done...explian

Question Posted / aravind rangaraj

3 Answers
5291 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

define table lookup and how may ways it can be done...explian..

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

define table lookup and how may ways it can be done...explian..

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

define table lookup and how may ways it can be done...explian..

Answer / srinu

WE CAN USE HASHING AND OTHER STEPS SPECIFIED

Is This Answer Correct ?

0 Yes

0 No

Post New Answer