How to select cases in SPSS in a stacked data set

I have a very large (949,000 obs.) stacked (long form) data set. I would like to select cases based on the presence of data in one variable but keep the other stacked data for that Unique ID. Does that make sense?

Do you have any thoughts?

Solution

You can certainly do this in Statistics. Use AGGREGATE with the person id as the break variable and, say, the mean as the summary statistic. Choose to have the aggregate stat added to the cases. Then just select those cases where the aggregate is not missing.

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