Thanks. I do know how to make the cell empty by using the cut or clear commands. I was wondering if it was possible in SPSS to delete a cell and have the rest of the column of cells below it shift upwards (like it does in Excel)?
------------------------------
Jeffrey Broadbent
------------------------------
Original Message:
Sent: Fri October 28, 2022 05:52 PM
From: Jon Peck
Subject: delete a cell in an spss data file
I'm not sure what you mean by deleting cells. Do you mean setting those values to missing? Excel doesn't care about the shape of your data, which is a frequent source of errors, but datasets in Statistics and traditional databases are always rectangular, so you can't literally delete cells within a case.
Using the Data Editor Data View, you can click in a cell and make it empty, and there are syntax ways to do this, too, but Statistics is not a spreadsheet.
Original Message:
Sent: 10/28/2022 5:17:00 PM
From: Jeffrey Broadbent
Subject: delete a cell in an spss data file
How do I delete a single cell (or a short set of three or four cells in a row, not the whole row) in an SPSS data file? In Excel this would be simple. But I cannot find a command to do that in SPSS.
------------------------------
Jeffrey Broadbent
------------------------------
#SPSSStatistics