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;

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;

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).

Answer / venu

join concept use to combine 3 or more tables with different
structures

Answer / ameenpasha

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.

Answer / sowjanya

2nd Answer is exactly corrrect.

Answer / laxman

second Answer corrrect.

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,

Explain what Proc glm does?

0 Answers  

what are several options for creating reports in web report studio? : Sas-bi

0 Answers  

Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers  

Can we use where and having clauses in a single SAS program. ex: proc sql;     select a,b,c from test      where state in 'KA'      and having <some condition>. Is the above program run correctly, if not why ?     

4 Answers   UHG,

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

2 Answers   Eval Source,

what is the difference between DUPKEY and NODUPKEY???

4 Answers   Cognizant, EXL,

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

0 Answers  

How many tiers in sas architecture?

2 Answers  

What is proc sql pass through facility?

4 Answers   L&T,

In the flow of DATA step processing, what is the first action in a typical DATA Step?

6 Answers   Accenture,

How do i read multiple spaces in datasets?

4 Answers   Quintiles,