How would you combine 3 or more tables with different
structures?
- 7 Answers
- 17395 Views
- I also Faced
- E-Mail Answers
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
How substr function works in sas?
What is the use of divide function?
what is the purpose of _error_? : Sas programming
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
how the sas basic syntax style described? : Sas-administrator
Name some categories in sas 9? : sas-grid-administration
In ARRAY processing, what does the DIM function do?
what is sas olap server? : Sas-di
Explain why double trailing @@ is used in input statement?
Have you used macros? For what purpose you have used? : sas-macro
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
how to change the execute of macro
How do you use the do loop if you don’t know how many times you should execute the do loop?
What is the difference between reading data from an external file and reading data from an existing data set?
What is the basic syntax of a sas program?
