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

I would use Merge statement to combine theree tables (SAS
Datasets). First you have to sort the datasets by common
variable. provide the condition with in merge statement.
For e.g. Three datasets are A, B, C and common var is SSN,
then

DATA Together;
Merge A (IN=A)
B (IN=B)
C (IN=C);
By SSN; Run;

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give e an example of..

2080


what is sas enterprise intelligence architecture? : Sas-bi

964


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

1040


what is broad cast agent? : Sas-bi

1045


what is data integration? : Sas-di

1098


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

997


What are pdv and it functions?

1116


Name few SAS functions?

1079


what is ae onset date n what is RDS

2545


what are the categories that sas informats are used to the place the data? : Sas-administrator

1025


how will you location sas platform applications available from web browser? : Sas-bi

1060


What are the scrubbing procedures in sas?

991


what is the effect of the options statement errors=1? : Sas programming

1042


What are the automatic variables for macro? : sas-macro

1224


What is run-group processing?

1141