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


Please Help Members By Posting Answers For Below Questions

Explain why double trailing @@ is used in input statement?

579


What would you change about your job?

1933


Give some examples where proc report’s defaults are different than proc print’s defaults?

607


what is operational data and operational system? : Sas-di

646


explain the function of substr in sas? : Sas-administrator

566






how to debug and test the sas program? : Sas-administrator

586


What is run-group processing?

632


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3073


How to limit decimal places for the variable using proc means?

610


Mention some common errors that are usually committed in sas programming.

596


What Proc glm does?

618


What will calendar procedure do?

609


AE datasets names? how many types?

2084


what are validation tools that are used in sas? : Sas-administrator

604


If money were no object, what would you like to do?

2697