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 is the use of sas management console? : Sas-di
What is the difference between INPUT and INFILE ?
how would you create multiple observations from a single observation? : Sas programming
Are you sensitive to code walk-throughs peer review or QC review?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what are several options for creating reports in web report studio? : Sas-bi
Differentiate between format and informat? : sas-grid-administration
Explain append procedure?
what is treatment emergent events and treatment emregent adverse event
What is a method to debug and test your SAS program?
How we can create SAS USER DEFINED CODE?
describe how to adjust the performance of data integrator? : Sas-di
what is null hypothesis? why do you consider that?
What do you know about sas and what we do? : sas-grid-administration
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming