Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6380 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 |
wat is sas? is a package or programming language?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
what is the difference between proc means and proc summary?
For clinical entire study how many tables will create approx?
What do the put and input function do?
Describe a time when you were really stuck on a problem and how you solved it?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
tell me about intnx, intcx functions?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
what versions of sas have you used (on which platforms)? : Sas programming
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Explain the use of proc gplot? : sas-grid-administration
Teradata 
