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

What are the data types does SAS contain?

1104


What are the 3 components in sas programming?

1190


Tell me more about the parameters in macro? : sas-macro

1049


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1248


how does sas handle missing values in assignment statements? : Sas programming

1017


why is sas considered self-documenting? : Sas programming

1142


What are the difference between ceil and floor functions in sas?

1345


How do you define proc in sas? : sas-grid-administration

1075


What are the features of SAS?

1030


What are the applications primarily used by business analyst? : Sas-bi

992


Name types of category in which SAS Informats are placed?

1142


Where do you use proc means over proc freq?

1106


How we can call macros with in data step? : sas-macro

1116


What is the basic syntax style in SAS?

1160


what is sas and what are the functions? : Sas-administrator

981