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 |
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Briefly describe 5 ways to do a "table lookup" in sas.
wt is a-z and a--z?
I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
Describe what are the different levels of administrative users in sas? : sas-grid-administration
what are the differences between proc report and proc tabulate?
how do you test for missing values? : Sas programming
What is difference between N and n????
What is by-group processing?
Explain the purpose of retain statement.