Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6448 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 has been your most common programming mistake? : Sas programming
what is option year cuttoff in sas
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
Explain data_null_?
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
At compile time when a SAS data set is read, what items are created?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
what is conditional processing?
how do u identify a macro variable
What are the prime responsibilities of data integration administrator? : Sas-di
Teradata 
