define table lookup and how may ways it can be
done...explian
Answers were Sorted based on User's Feedback
Answer / vijaya mekala
Table lookup is a process of retriving information from
second dataset and add to first data set. different ways to
do look up.
1. data step with merge function.
2. set statement and Key option.
3. Proc sql into clause, inner join, subquery
4. proc format 5. conditional logics if, where, update
statements. 6. arrays with do loops 7. update statement.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rc
I guess lot of ways, but I cna quickly think of two.
1. Create format with code and values, Put the formats in a
catalog and set option for fmtsearch and apply format to
teh variable.
2. Create temp dataset with input data in datastep. And use
proc SQL to join or use DATA step merge.
Is This Answer Correct ? | 2 Yes | 0 No |
What is the function of Stop statement in a SAS Program?
Name statements that function at both compile and execution time?
Differentiate between format and informat? : sas-grid-administration
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 is the effect of the options statement errors=1? : Sas programming
What is the purpose of using the N=PS option?
"What is the difference between proc sort nodup and proc sort nodupkey?"
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
How can I remove header from output data set?
how to debug and test the sas program? : Sas-administrator
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?