Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6432 Views
- I also Faced
- E-Mail Answers
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 |
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
how do you validate sas program?
What is the general format of function in sas? : sas-grid-administration
what is broad cast agent? : Sas-bi
Describe the ways in which you can create macro variables?
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
what is the difference between infile and input? : Sas-administrator
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
In PROC PRINT, can you print only variables that begin with the letter “A”?
describe about physical data integration? : Sas-di
Why double trailing @@ is used in input statement?
What are the functions done while Compilation...?
Teradata 
