Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6377 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the difference between ceil and floor functions in sas?
What are all the problems you faced while validating tables and reports?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Explain what is the use of proc gplot?
Difference between sum function and using “+” operator?
Do you know the features of sas?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
what is the use of sas management console? : Sas-di
What is run-group processing?
How would you define the end of a macro?
Which function is used to count the number of intervals between two sas dates?
How to create a permanent sas data set?
What are types of transport files?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
why is a stop statement needed for the point=option on a set statement? : Sas programming
