How would you combine 3 or more tables with different
structures?
- 7 Answers
- 17405 Views
- I also Faced
- E-Mail Answers
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 use of %include statement?
Explain bmdp procedure?
what is the difference between floor and ceil functions in sas? : Sas-administrator
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Do you need to rearrange the order of the data for the report?
What is the difference between proportion and average?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
What do you code to create a macro? : sas-macro
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
How do you test for missing values?
What are the 3 components in sas programming?
how does sas handle missing values in procs? : Sas programming
What is the basic syntax style in SAS?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Define run-group processing?
