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 |
i want to upload titles and footnotes to excel file?how it is possible?
What are the differences between proc means and proc summary?
how does sas handle missing values in formats? : Sas programming
how would you determine the number of missing or nonmissing values in computations? : Sas programming
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Name and describe three SAS functions that you have used, if any?
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
how does sas handle missing values in an update? : Sas programming
What is the purpose of _character_ and _numeric_?
how to delete the duplicate columns permanently in SQL
how do you validate sas program?
Explain proc univariate?