Write and execute IBM SPSS Statistics syntax following SPSS conventions and run SPSS MCP analyses defensively. Use when the user asks to run statistical analysis (frequencies, descriptives, regression, t-test, ANOVA, correlations, factor analysis, crosstabs, MDS/PROXSCAL, clustering, survival, mixed models, etc.), write or review SPSS syntax/code, explore or summarize .sav data files, compute/recode/transform variables, clean or restructure data in SPSS, diagnose SPSS MCP timeouts or syntax incompatibilities, or use SPSS MCP tools safely with smoke tests first. Triggered by keywords like SPSS, .sav, 分析, 频率, 回归, 方差分析, 相关, 描述统计, t检验, 因子分析, 交叉表, 编码, 临近映射, MDS, PROXSCAL, or any request involving statistical analysis with SPSS data files.
spss_check_status first to confirm SPSS batch is available..sav file, call spss_file_summary or spss_read_metadata to know variable names, types, and labels before writing syntax.DESCRIPTIVES, FREQUENCIES, or DISPLAY DICTIONARY.spss_run_syntax and add optional subcommands only after the minimal command works.Viewer file:, immediately archive results to spss_result/. See Output Archiving below..env is actually being loaded and restart the MCP session if needed.| Rule | Correct | Wrong |
|---|---|---|
| Keywords uppercase | FREQUENCIES | frequencies |
| Period ends every command | DESCRIPTIVES VARIABLES=age. | DESCRIPTIVES VARIABLES=age |
Subcommands start with / | /STATISTICS=MEAN | STATISTICS=MEAN |
| Strings in single quotes | 'myfile.sav' | "myfile.sav" |
Comments with * | * My comment. | # My comment |
| Missing value code | MISSING VALUES age (99). | — |
Always begin a syntax block with:
* ============================================================
* 分析目的: [简述目的]
* 数据文件: [文件路径]
* 日期: [YYYY-MM-DD]
* ============================================================
GET FILE='C:/Data/myfile.sav'.
* 频率表 + 描述统计
FREQUENCIES VARIABLES=var1 var2
/STATISTICS=MEAN MEDIAN MODE STDDEV
/ORDER=ANALYSIS.
* 描述统计（仅连续变量）
DESCRIPTIVES VARIABLES=score age income
/STATISTICS=MEAN STDDEV MIN MAX VARIANCE.
* 独立样本 t 检验
T-TEST GROUPS=gender(1 2)
/VARIABLES=score.
* 单因素方差分析
ONEWAY score BY group
/STATISTICS DESCRIPTIVES
/POSTHOC=TUKEY ALPHA(.05).
* 线性回归
REGRESSION
/DEPENDENT score
/METHOD=ENTER age edu income.
* 交叉表 + 卡方
CROSSTABS
/TABLES=gender BY jobcat
/STATISTICS=CHISQ
/CELLS=COUNT ROW COLUMN.
* 计算新变量
COMPUTE bmi = weight / (height * height).
VARIABLE LABELS bmi '体质指数'.
EXECUTE.
* 变量重新编码
RECODE age (18 THRU 35=1)(36 THRU 55=2)(56 THRU HI=3) INTO age_group.
VALUE LABELS age_group 1'青年' 2'中年' 3'老年'.
EXECUTE.
SYMMETRIC, EUCLID, or CONFIGURATION are valid in the installed syntax variant without testing.After every mcp__spss__* tool call that produces output (i.e., result contains Viewer file:), immediately:
1. Ensure directory exists
mkdir -p <cwd>/spss_result
2. Determine next sequence number — Glob spss_result/[0-9][0-9]_*, take max prefix + 1 (start at 01).
3. Map tool → type label
| Tool / main command | Label |
|---|---|
spss_descriptives / DESCRIPTIVES | descriptives |
spss_frequencies / FREQUENCIES | frequencies |
spss_twostep_cluster / QUICK CLUSTER | kmeans_cluster |
spss_cluster_hierarchical / CLUSTER | hierarchical_cluster |
spss_anova / ONEWAY | oneway_anova |
spss_t_test / T-TEST | ttest |
spss_regression / REGRESSION | regression |
spss_correlations / CORRELATIONS or NONPAR CORR | correlation |
spss_factor / FACTOR | factor_analysis |
spss_reliability_alpha / RELIABILITY | reliability |
spss_logistic_regression / LOGISTIC REGRESSION | logistic_regression |
spss_glm_univariate / GLM | glm_univariate |
spss_manova / MANOVA | manova |
spss_mixed / MIXED | mixed_model |
spss_crosstabs / CROSSTABS | crosstabs |
spss_nonparametric_tests / NPAR TESTS | nonparametric |
spss_normality_outliers / EXAMINE | normality |
spss_run_syntax (mixed) | infer from dominant command |
4. Copy .spv — Extract path after Viewer file: from tool result, copy to spss_result/NN_<label>.spv. Skip if path missing.
5. Write .sps — Create spss_result/NN_<label>.sps with header block + full syntax:
************************************************************
* 文件名：NN_<label>.sps
* 分析类型：<中文全称>
* 数据文件：<.sav 路径>
* 因变量 / 预测变量 / 分组变量：<变量名>（若适用）
* 关键参数：<聚类数、事后检验、CI水平等>
* 缺失值处理：<LISTWISE / PAIRWISE>
* 执行日期：<YYYY-MM-DD>
************************************************************
<完整 SPSS 语法>
Constraints: sequence number is global (not per-type); parallel tool calls each get their own number; read-only tools (spss_list_files, spss_file_summary, spss_import_csv, spss_check_status, etc.) do not trigger archiving.
.env behavior, success=True with warnings, or advanced procedure incompatibilities.