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
How are numeric and character missing values represented internally?
What is the difference between reading data from an external file and reading data from an existing data set?
How do you control the number of observations and/or variables read or written?
Explain the difference between nodup and nodupkey options?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What is Linear Regression?
How is character variable converted into numeric variable and vice versa?
Tell e how how dealt with..
do you prefer proc report or proc tabulate? Why? : Sas programming
List out some key concept of SAS
What is program data vector (pdv)?
What is the purpose of trailing @ and @@? How do you use them?
what are validation tools that are used in sas? : Sas-administrator
what is operational data and operational system? : Sas-di
Mention what are the data types does SAS contain?