Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6659 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 |
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
what is program data vector? : Sas-administrator
Tell me about % include and % eval? : sas-macro
how do you read binary data in sas?
what is the use of proc sql?
What does P-value signify about the statistical data?
How do you define proc in sas? : sas-grid-administration
What can you learn from the SAS log when debugging?
what type of graphs we will create(for 2+years candidates)?
what is sas? is a package or tool? give me introduction about sas?
how to perform paired t-test using Base/SAS & SAS/Stat?
Teradata 
