Briefly describe 5 ways to do a "table lookup" in sas.

Question Posted / nikosh

4 Answers
21186 Views
Quintiles, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Briefly describe 5 ways to do a "table lookup" in sas...

Answer / guest

Arrays
Index
Merg statement
Hashes
proc format
SQL JOINS

Is This Answer Correct ?

9 Yes

2 No

Briefly describe 5 ways to do a "table lookup" in sas...

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

Briefly describe 5 ways to do a "table lookup" in sas...

Answer / rinky

Arrays
Index
Merg statement
Hashes
SQL JOINS

Is This Answer Correct ?

0 Yes

0 No

Briefly describe 5 ways to do a "table lookup" in sas...

Answer / lakshmi

update
modify
fact to dimension
sql joins
merge statement

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SAS Interview Questions

Approximately what date is represented by SAS date value of 730

9 Answers

explain the use of % includes a statement in sas? : Sas-administrator

0 Answers

Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)

1 Answers

how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?

3 Answers CMC,

What’s the difference between var b1 – b3 and var b1 — b3?

0 Answers

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

8 Answers Verinon Technology Solutions,

What does P-value signify about the statistical data?

0 Answers

How would you code a merge that will keep only the observations that have matches from both sets.

5 Answers Accenture, Bank Of America,

What is _n_?

23 Answers Accenture,

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers WNS,

What is the pound sign used for the DATA _NULL_?

14 Answers

What is SAS?

0 Answers

For more SAS Interview Questions Click Here