Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6573 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 |
Difference b/n proc means and proc summary procedures?
What is the function of output statement in a SAS Program?
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
what is the basic structure sas administrator? : Sas-administrator
what is cummaltive frequency,and varience in proc unviarte
AE datasets names? how many types?
Are you involved in writing the inferential analysis plan? Tables specfications?
How would you delete duplicate observations?
Mention what are the data types does SAS contain?
Where do you use proc means over proc freq?
How would you remove a format that has been permanently associated with a variable? ________________
How would you include common or reuse code to be processed along with your statements?
Teradata 
