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 SAS USER DEFINED CODE?

2077


Differentiate between format and informat? : sas-grid-administration

1044


Explain the difference between nodup and nodupkey options?

1012


Explain the use of proc print and proc contents?

946


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

2164


Mention the validation tools used in SAS?

1147


Explain data step in SAS

1062


how would you determine the number of missing or nonmissing values in computations? : Sas programming

1125


what other sas products have you used and consider yourself proficient in using? : Sas programming

1096


What are the difficulties u faced while doing vital signs table or dataset?

2370


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

1046


how many types of prompts are there? : Sas-bi

1066


what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1009


Enlist the syntax rules followed in sas statements.

1074


what is sas business intelligence? : Sas-bi

1161