How to combine/merge rows in SPSS Modeler?
Please advice how to transform the original dataset to the expected output as shown below on SPSS Modeler?
It is expected to merge the values of all rows shared the same ID No.
Solution
If SPSS syntax is availabel to you, the following aggregation command should do the trick:
aggregate outfile=* /break=ID /date_1 from_1 to_1 date_2 from_2 to_2=
max(date_1 from_1 to_1 date_2 from_2 to_2)
- Reading .sav file into R
- UnicodeDecodeError: 'charmap' codec can't decode byte 0x81 in position 55: character maps to <undefined>
- Get the sub colnames of a dataframe from SPSS to R (read.spss)
- ODBC error when trying to connect MS Excel to SPSS file on fileserver
- Why does converting a nested python dictionary into a pandas dataframe result in "has no attribute 'items' error?
- Simple contrasts output from SPSS in R
- SPSS If statement with multiple conditions
- Importing SPSS dataset into Python
- SPSS Custom Tables Nesting
- Change value labels or delete specific value labels
- pyreadstat read and write spss without data loss
- Efficient way for converting Yes/No to 1/0 in Excel or SPSS
- Fill in missing values in a row based on another column SPSS syntax?
- Pivot variables in SPSS with `CASESTOVARS` and specify the resulting column names
- Convert string YYYY-MM-DD to MM/DD/YYYY date in SPSS?
- R - changing values to labels permanently in labelled data
- SPSS match files results in empty column
- calculation with different values in SPSS
- How do I shorten super long variable labels of an SPSS file in R?
- Dynamically remove columns with no variance in syntax
- SPSS Syntax: spliting one categorical variable into multiple yes/no variables
- Translating a simple data check method from SAS into SPSS (crosstabs for 3+ variables fed into output dataset)
- SPSS: How to access values of variables, where the names of the variables I want are the values of another variable
- How do I write a DO IF command asking to compute something ONLY if the value of that case is missing? [SPSS]
- Creating one variable from three, SPSS
- How to properly invoke Python 3 script from SPSS syntax window using SCRIPT command (+ additional problems during runtime)
- What's a pythonic way (native function in pandas) to count occurrences of a certain value within cases (SPSS COUNT equivalent)?
- In a dataset where individuals have multiple rows of data per enrollment, how can I make a variable that indicates enrollment instance (1st/2nd/etc.)?
- Import .spv file into R / convert into .csv
- SAS no longer automatically converts user-defined formats to SPSS value labels