define table lookup and how may ways it can be
done...explian
Answer Posted / 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 |
Post New Answer View All Answers
If money were no object, what would you like to do?
how will you locate the sas platform applications? : Sas-bi
How would you identify a macro variable?
Do you need to know if there are any missing values?
what is program data vector? : Sas-administrator
how can you put a "trace" in your program? : Sas programming
What system options would you use to help debug a macro? : sas-macro
What are types of transport files?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
what is sas metadata repository? : Sas-bi
explain the main difference between the nodup and nodupkey options? : Sas-administrator
name some data transformation used in sas di? : Sas-di
Explain the main difference between the sas procedures and functions? : Sas-administrator
what are the considerations when picking a SAS/STAT procedure?
Explain bmdp procedure?