Briefly describe 5 ways to do a "table lookup" in sas.

Answer Posted / tulika

DAta step and Merge Statement
SQL Inner Join
SQL subquery
Format procedure and Put function
Call execute routine

for more information look up
http://www2.sas.com/proceedings/sugi27/p011-27.pdf

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

806


what is the use of proc sql? : Sas programming

600


Explain data step in SAS

633


how many types prompting framework can be broken down to? : Sas-bi

637


What does the RUN statement do?

856






what is data governance? : Sas-di

627


How long can a macro variable be? A token? : sas-macro

721


Explain the purpose of substr functions in sas programming.

569


Which statement does not perform automatic conversions in comparisons?

1207


For clinical entire study how many tables will create approx?

1526


What is connection profile? : sas-grid-administration

654


Explain what is the use of proc gplot?

708


What is the purpose of trailing @ and @@? How do you use them?

617


What are all the problems you faced while validating tables and reports?

3016


State the difference between INFORMAT and FORMAT ?

599