spss_star_join
Combine two SPSS .sav data files using SQL-style STAR JOIN on a matching key, optionally selecting specific fields from each table. Requires IBM SPSS Statistics.
Instructions
SQL-style join of two .sav files: STAR JOIN /SELECT ... /FROM ... /JOIN ... ON key=key. base_key/join_key: matching variable names; select_fields: optional list like ['t0.age','t1.income']. Requires IBM SPSS Statistics.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_key | Yes | ||
| join_key | Yes | ||
| base_file | Yes | ||
| join_file | Yes | ||
| base_alias | No | t0 | |
| join_alias | No | t1 | |
| output_path | No | joined.sav | |
| select_fields | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |