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 is the purpose of _character_ and _numeric_?

1068


Compare sas with other data analytics tools.

1034


What is the differnce between SDTM 3.1.2 to 3.1.1 version

5077


What is a pdv and what are its functions?

1154


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

1081


Mention few capabilities of sas framework.

1193


What are the difference between the sas data step and sas procs?

1187


What is the maximum length of the macro variable?

1181


Describe what are the different levels of administrative users in sas? : sas-grid-administration

1038


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1163


describe about metadata object? : Sas-di

1073


What commands are used in the case of including or excluding any specific variables in the data set?

1097


name some data transformation used in sas di? : Sas-di

972


To what type of programms have you used scratch macros?

2571


Mention what are the data types does SAS contain?

1153