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 |
name several ways to achieve efficiency in your program? : Sas programming
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
why is the use of Retrive statement and give me with example?
What is the Program Data Vector (PDV)? What are its functions?
Name some categories in sas 9? : sas-grid-administration
What are the limitations for memory allocation for SAS variables
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
Explain the purpose of substr functions in sas programming.
How to include or exclude specific variables in a data set?
Can you suggest us materials for sdtm mapping?