[学习资料] 【求教】关于数据合并 [推广有奖]

11楼

tommyecnu 发表于 2010-12-23 00:14:26

如果你把合肥、北京数据汇总，是不是会出现数据重叠。那你这样做就没有意义。

12楼

chyua 发表于 2010-12-23 14:54:26

为什么有好的方法不用呢？

13楼

eveningbmu 发表于 2010-12-23 15:32:16

把以下内容存为桌面的1.txt
合肥             500             200
北京             300             600
济南             200             400

以下内容存为桌面的2.txt
合肥             500             200
北京             300             600
天津             200             400

运行以下语法：

GET DATA  /TYPE = TXT
/FILE = 'C:\Documents and Settings\user\桌面\1.txt'
/DELCASE = LINE
/DELIMITERS = " "
/ARRANGEMENT = DELIMITED
/FIRSTCASE = 1
/IMPORTCASE = ALL
/VARIABLES =
V1 A4
V2 F3.0
V3 F3.0
.
CACHE.
EXECUTE.

SORT CASES BY  V1 (A) .

SAVE OUTFILE='C:\Documents and Settings\user\桌面\1.sav'
/COMPRESSED.

GET DATA  /TYPE = TXT
/FILE = 'C:\Documents and Settings\user\桌面\2.txt'
/DELCASE = LINE
/DELIMITERS = " "
/ARRANGEMENT = DELIMITED
/FIRSTCASE = 1
/IMPORTCASE = ALL
/VARIABLES =
V1 A4
V2 F3.0
V3 F3.0
.
CACHE.
EXECUTE.

SORT CASES BY  V1 (A) .

SAVE OUTFILE='C:\Documents and Settings\user\桌面\2.sav'
/COMPRESSED.

GET  FILE='C:\Documents and Settings\user\桌面\1.sav'.

ADD FILES /FILE=*
/FILE='C:\Documents and Settings\桌面\user\2.sav'.
EXECUTE.

AGGREGATE
  /OUTFILE=*
  /BREAK=V1
  /V2_sum = SUM(V2) /V3_sum = SUM(V3).