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 |
What is the role of sas grid administrator? : sas-grid-administration
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
If money were no object, what would you like to do?
What is the difference between INPUT and INFILE ?
Can you explain the process of calendar?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
what techniques and/or procs do you use for tables? : Sas programming
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
What is the difference between %local and %global?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?