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 |
Are you familiar with special input delimiters How are they used?
what techniques and/or procs do you use for tables? : Sas programming
what is the difference between informat$8. $char8.
What do you understand by the term Normal Distribution?
how can u create zero observation dataset?
how does sas handle missing values in procs? : Sas programming
What is instream data in SAS?
What is your favorite all time computer book? Why?
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
if we dont want to print output what we have to do..???give syntax..???
8 Answers Accenture, GSK GlaxoSmithKline,