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 Proc glm does?

1023


Difference between sum function and using “+” operator?

1084


explain the proc in sas? : Sas-administrator

1034


Describe 5 ways to do a “table lookup” in SAS?

1087


what is the effect of the options statement errors=1? : Sas programming

1001


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1012


: and & modifiers.

1335


What is a pdv and what are its functions?

1046


Briefly explain input and put function?

1030


What are the prime responsibilities of data integration administrator? : Sas-di

1002


what is the difference between nodup and nodupkey options? : Sas programming

1113


Tell me about % include and % eval? : sas-macro

1097


explain the key concept of sas? : Sas-administrator

941


Differentiate between ceil and floor functions.

1103


How to sort in descending order?

1200