Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6558 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 |
What is the difference between one to one merge and match merge? Give an example.
: and & modifiers.
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?
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
explain the key concept of sas? : Sas-administrator
what is the purpose of _error_? : Sas programming
describe the interaction table in sas di? : Sas-di
How experienced are you with customized reporting and use of Data _Null_ features?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
What is PDV?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Teradata 
