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

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2306


what can you learn from the sas log when debugging? : Sas programming

1141


what is intially documentation in sas?

5129


do you prefer proc report or proc tabulate? Why? : Sas programming

1031


What are the advantages of using sas?

1189


where to use sas business intelligence? : Sas-bi

1161


what techniques and/or procs do you use for tables? : Sas programming

1101


Difference between SAS STATA & SPSS?

1177


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1110


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1103


how do you test for missing values? : Sas programming

1099


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2229


what are sas/access and sas/connect? : Sas programming

1039


Name few SAS functions?

1144


what is treatment emergent events and treatment emregent adverse event

2448