How would you combine 3 or more tables with different
structures?
Answer Posted / akshay surya
Yes we can use joins and Merge statements as well. But in
bothe the scenarios, a commmon variable should be there for
all tables(can have different structures). And also one
should take care when tables contains too many duplicate
values.(may be eliminating the duplicate values is probably
the best way to get the intended result, otherwise output
result will be the reuslt of a cartesian product).
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What Proc glm does?
explain about data integrator metadata reports? : Sas-di
what are the component of range? : Sas-bi
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
Why and when do you use proc sql?
What will calendar procedure do?
Intern stastical programmer written test
What is the basic structure of a sas program?
Mention what is the difference between nodupkey and nodup options?
Of all your work, where have you been the most successful?
how can you put a "trace" in your program? : Sas programming
Differences between where and if statement?
what is sas business intelligence? : Sas-bi
What is the maximum and minimum length of macro variable
what is sas and what are the functions? : Sas-administrator