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

sort all datasets before going to merge
data abc ;
merge aa (in=a) bb (in=b) cc(in=c) ;
by empid /*by variable*/
if a or b or c;/*based on your requirement*/
run;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2079


What do you know about symput and symget?

1186


What areas of SAS are you most interested in?

1492


what are all the reports you generated in your recent project?

2167


What is program data vector (pdv)?

1223


What are the five ways to do a table lookup in sas? : sas-grid-administration

1023


If money were no object, what would you like to do?

3158


which date functions advances a date time or date/time value by a given interval? : Sas programming

924


What are the data types that sas contain?

1144


explain about data integrator metadata reports? : Sas-di

1059


What is the use of divide function?

1028


what are _numeric_ and _character_ and what do they do? : Sas programming

1128


what is ae onset date n what is RDS

2501


where are dashboard components are created and maintained? : Sas-bi

990


What is maximum number of rows and cols can be handled in SAS?

1521