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
What is a macro routine?
Explain the difference between informat and format with an example.
Mention sas system options to debug sas macros.
What does the RUN statement do?
What do you know about symput and symget?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How can you create a macro variable with in data step? : sas-macro
What is the differnce between SDTM 3.1.2 to 3.1.1 version
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
which date function advances a date, time or datetime value by a given interval? : Sas programming
how many types of prompts are there? : Sas-bi
What are the data types in sas?
What are the scrubbing procedures in sas?
What is the use of PROC gplot?
what is proc Index? and what is proc document?