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 use of PROC gplot?
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
what is sas olap server? : Sas-di
how can u extract,transform and loading?
What are the statements that are executed only?
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
Describe the ways in which you can create a macro variable?
what the use of proc glm
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
what is transformation in sas data integration? : Sas-di
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT