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
what is factor analysis? : Sas-administrator
what is hash files in sas and why we are using this one in sas?
What is the role of sas grid administrator? : sas-grid-administration
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Why double trailing @@ is used in input statement?
How to read an input file in sas?
for report generation which one you used proc report or data_null_?
why is sas considered self-documenting? : Sas programming
how will you location sas platform applications available from web browser? : Sas-bi
how would you determine the number of missing or nonmissing values in computations? : Sas programming
explain about sas business intelligence? : Sas-bi
How does the internal authentication work in sas? : sas-grid-administration
What are the different types of sas functions?
If a variable contains only numbers, can it be a character data type?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?