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 broad cast agent? : Sas-bi
what is information maps?
What is the basic syntax of a sas program?
Define run-group processing?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
What is the difference between one to one merge and match merge? Give an example.
Describe crosslist option in tables statement?
what r the job openings SAS for fresher graduates !
Which date function advances a date, time or datetime value by a given interval?
what is the difference between nodup and nodupkey options? : Sas programming
: and & modifiers.
What does P-value signify about the statistical data?
Differentiate between sas functions and sas procedures.
which date function advances a date, time or datetime value by a given interval? : Sas programming