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
What is the purpose of _character_ and _numeric_?
Compare sas with other data analytics tools.
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What is a pdv and what are its functions?
how many types of prompts are there? : Sas-bi
Mention few capabilities of sas framework.
What are the difference between the sas data step and sas procs?
What is the maximum length of the macro variable?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
describe about metadata object? : Sas-di
What commands are used in the case of including or excluding any specific variables in the data set?
name some data transformation used in sas di? : Sas-di
To what type of programms have you used scratch macros?
Mention what are the data types does SAS contain?