spss
How to count cases with the same ID but different values on a second variable using SPSS?
I have a problem with SPSS. For instance, the person with 16 ID at the start of SPSS file is affiliated with both boston scientific coorp and american water works. Can I detect how many cases like this (in percentage and number)?
Solution
- Define duplicates based on the two variables:
data - identify duplicate cases- Define matching cases bypersonidandname; this will create a new variable that identifies cases with the samepersonidandnamecombination - Apply a filter to exclude duplicates:
data -selecte cases - Perform frequency analysis on
personid: e.g.,analyze - descriptives - frequencies
- 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
- 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?