Interested to Buy Any Domain ? << Click Here >> for more details...
How would you combine 3 or more tables with different
structures?
- 7 Answers
- 18299 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nandu
sort all datasets before going to merge
data abc ;
merge aa (in=a) bb (in=b) cc(in=c) ;
by empid /*by variable*/
if a or b or c;/*based on your requirement*/
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / akshay surya
Yes we can use joins and Merge statements as well. But in
bothe the scenarios, a commmon variable should be there for
all tables(can have different structures). And also one
should take care when tables contains too many duplicate
values.(may be eliminating the duplicate values is probably
the best way to get the intended result, otherwise output
result will be the reuslt of a cartesian product).
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / venu
join concept use to combine 3 or more tables with different
structures
| Is This Answer Correct ? | 3 Yes | 3 No |
I think sort them with common variables and use merge statement.
No matter if they are of different structures, only that the result will have missing values for nonmatching records. If you wanna avoid this use In() operator OR
use proc sql with Join clause which will just pick matching records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain append procedure?
How would you keep from overlaying the a SAS set with its sorted version?
How do you specify the number of iterations and specific condition within a single do loop?
Give some examples where proc report’s defaults are same as proc print’s defaults?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is a put statement?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
explain about data integrator metadata reports? : Sas-di
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
how do you validate sas program?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
Mention the validation tools used in SAS?
Teradata 
