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 many display types available in sas bi dashboard? : Sas-bi
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is the basic syntax style in SAS?
How to specify variables to be processed by the freq procedure?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
What versions of SAS have you used (on which platforms)?
how we can create optional or required parameters in SAS macro...
what is the function of catx syntax? : Sas-administrator
Mention few ways with which a “table lookup’ is done in sas programming.
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
How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.
how to intersect the tables by using PROC MIXED?