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 frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
For what purpose(s) would use the RETURN statement?
What do you understand by the term Normal Distribution?
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
name some data transformation used in sas di? : Sas-di
What does a PROC TRANSPOSE do?
what is option year cuttoff in sas
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
what is the formula to measure Baseline
Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?
What SAS statements would you code to read an external raw data file to a DATA step?
Explain what is data step?