Briefly describe 5 ways to do a "table lookup" in sas.
Answers were Sorted based on User's Feedback
Answer / guest
Arrays
Index
Merg statement
Hashes
proc format
SQL JOINS
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / 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 |
Answer / lakshmi
update
modify
fact to dimension
sql joins
merge statement
Is This Answer Correct ? | 0 Yes | 0 No |
how to debug and test the sas program? : Sas-administrator
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What are the ways in which macro variables can be created in sas programming?
what is the use of proc contents and proc print in sas? : Sas-administrator
how to generate report for 0 observation dataset?
Why is SAS considered self-documenting?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Can we replace a dataset into view?
How to specify variables to be processed by the freq procedure?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
how many display types available in sas bi dashboard? : Sas-bi