spssspss-modeler
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)
- 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
- Concat Valuelabels with IF condition in SPSS
- SPSS: trying to summarise the ranking of items, from a survey with drag&drop question
- SPSS - How to isolate the maximum value in a variable so you can use it in syntax?
- How to create a variable that counts how many other cases has the same ID in SPSS