i try to merge two data file , using the following syntax :-
********************************************.
* This section
creates the sample data
file=result2.sav.
********************************************.
SET SEED=87654321.
INPUT PROGRAM.
LOOP #I = 1
TO 2.
COMPUTE coy=
TRUNC(UNIFORM(1)*3)+1.
COMPUTE c_class=
TRUNC(UNIFORM(1)*3)+1.
END CASE.
END LOOP.
END FILE.
END INPUT PROGRAM.
EXECUTE.
sort case by coy (a).
Save OutFILE='C:\Program Files\SPSS\test\result2.sav'.
********************************************.
* This section creates
the sample data
file=result1.sav.
********************************************.
SET SEED=87654321.
INPUT PROGRAM.
LOOP #I = 1
TO 10.
COMPUTE coy=
TRUNC(UNIFORM(1)*2)+1.
COMPUTE sls_amt=
TRUNC(UNIFORM(1)*50)+1.
END
CASE.
END LOOP.
END FILE.
END INPUT
PROGRAM.
EXECUTE.
sort case by coy (a).
format sls_amt (dollar9).
Save OutFILE='C:\Program Files\SPSS\test\result1.sav'.
Get FILE='C:\Program Files\SPSS\test\result1.sav'.
********************************************.
* This section match
both result1.sav merge with
result2.sav.
********************************************.
MATCH FILES /FILE=*
/FILE='C:\Program
Files\SPSS\Test\result2.sav'
/BY coy.
EXECUTE.
Save OutFILE='C:\Program Files\SPSS\test\result3.sav'.
list coy sls_amt c_class.
* i get the result as following :-...
COY SLS_AMT C_CLASS
1.00
$35 1.00
1.00
$7 .
1.00 $48
.
1.00
$7 .
1.00 $17
.
2.00
$48 3.00
2.00 $45
.
2.00
$43 .
2.00 $24
.
2.00
$37 .
* what i need to achieve as follwing :-..
COY SLS_AMT C_CLASS
1.00
$35 1.00
1.00 $7
1.00
1.00
$48 1.00
1.00 $7
1.00
1.00
$17 1.00
2.00 $48
3.00
2.00
$45 3.00
2.00 $43
3.00
2.00
$24 3.00
2.00 $37
3.00
Can you pls help me to modify the above syntax , so that i can get the
result i want.
TIA.