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 / ameenpasha

I think sort them with common variables and use merge statement.
No matter if they are of different structures, only that the result will have missing values for nonmatching records. If you wanna avoid this use In() operator OR

use proc sql with Join clause which will just pick matching records.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you include common or reuse to be processed along with your statements?

2316


what are sas bi dashboard components? : Sas-bi

1113


what is ae onset date n what is RDS

2461


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1132


Explain why double trailing @@ is used in input statement?

1008


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

997


Explain the purpose of retain statement.

1006


how do you test for missing values? : Sas programming

997


explain the function of substr in sas? : Sas-administrator

954


what are several options for creating reports in web report studio? : Sas-bi

1076


What is the use of PROC gplot?

1067


what are validation tools that are used in sas? : Sas-administrator

1001


Name validation tools used in SAS

1102


What is the maximum and minimum length of macro variable

1166


What is the sas data set? : sas-grid-administration

920