Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are pdv and it functions?

1151


Give an example where SAS fails to convert character value to numeric value automatically?

1093


what is treatment emergent events and treatment emregent adverse event

2407


how to do user inputs and command line arguments in sas?

3050


What does the RUN statement do?

1308


how sas deals with business intelligence? : Sas-bi

1056


What is the difference between where and if statement?

1117


how does sas handle missing values in a merge? : Sas programming

1051


What is the role of administrative users? : sas-grid-administration

1084


Differentiate between ceil and floor functions.

1163


Explain bmdp procedure?

1044


how to debug and test the sas program? : Sas-administrator

1040


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1082


What are the differences between proc means and proc summary?

1146


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1288