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

Tell e how how dealt with..

2212


How many data types are there in SAS?

1061


What do you know about sas data set?

1089


how can you put a "trace" in your program? : Sas programming

1040


How are numeric and character missing values represented internally?

1647


What makes sas stand out to be the best over other data analytics tools?

1046


How can sas program be validated?

1011


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1524


which features do you use to check the data validations and errors? : Sas-administrator

1041


Explain substr function?

1074


What are the 3 components in sas programming?

1183


Explain the difference between informat and format with an example.

1149


What do the put and input function do?

1042


Tell e how how dealt with..

2239


What are the limitations for memory allocation for SAS variables

1465