SPSS Statistics

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------

#SPSSStatistics

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------

#SPSSStatistics

Thanks Jon. Will deleting option (in OUTPUT MODIFY) appear in further versions of Statistics?

------------------------------
Konrad Gałuszko
------------------------------

Original Message:
Sent: Wed July 20, 2022 08:34 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I can't be sure that this works in older versions of Statistics, but this code using SPSSINC MODIFY TABLES hides selected rows, and they do not appear in the Excel file.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT="f"
DIMENSION= ROWS LEVEL = -1
PROCESS = PRECEDING HIDE=TRUE
/STYLES  APPLYTO=BOTH.

The SELECT condition could be a list of row labels, each quoted.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------
#SPSSStatistics

Original Message:
Sent: 7/20/2022 8:39:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

Thanks Jon. Will deleting option (in OUTPUT MODIFY) appear in further versions of Statistics?

------------------------------
Konrad Gałuszko
------------------------------

Original Message:
Sent: Wed July 20, 2022 08:34 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I can't be sure that this works in older versions of Statistics, but this code using SPSSINC MODIFY TABLES hides selected rows, and they do not appear in the Excel file.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT="f"
DIMENSION= ROWS LEVEL = -1
PROCESS = PRECEDING HIDE=TRUE
/STYLES  APPLYTO=BOTH.

The SELECT condition could be a list of row labels, each quoted.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------
#SPSSStatistics

I'm asking about option to not include hidden rows/columns in Excel output. Now, when I run OUTPUT MODIFY data still exist in Excel but are hidden (which is unconvenient while, for example, copying).

------------------------------
Konrad Gałuszko
------------------------------

Original Message:
Sent: Wed July 20, 2022 08:47 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I have no information on that, but the export already excludes hidden parts.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 8:39:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

Thanks Jon. Will deleting option (in OUTPUT MODIFY) appear in further versions of Statistics?

------------------------------
Konrad Gałuszko

Original Message:
Sent: Wed July 20, 2022 08:34 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I can't be sure that this works in older versions of Statistics, but this code using SPSSINC MODIFY TABLES hides selected rows, and they do not appear in the Excel file.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT="f"
DIMENSION= ROWS LEVEL = -1
PROCESS = PRECEDING HIDE=TRUE
/STYLES  APPLYTO=BOTH.

The SELECT condition could be a list of row labels, each quoted.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------
#SPSSStatistics

Original Message:
Sent: 7/20/2022 9:03:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

I'm asking about option to not include hidden rows/columns in Excel output. Now, when I run OUTPUT MODIFY data still exist in Excel but are hidden (which is unconvenient while, for example, copying).

------------------------------
Konrad Gałuszko
------------------------------

Original Message:
Sent: Wed July 20, 2022 08:47 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I have no information on that, but the export already excludes hidden parts.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 8:39:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

Thanks Jon. Will deleting option (in OUTPUT MODIFY) appear in further versions of Statistics?

------------------------------
Konrad Gałuszko

Original Message:
Sent: Wed July 20, 2022 08:34 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I can't be sure that this works in older versions of Statistics, but this code using SPSSINC MODIFY TABLES hides selected rows, and they do not appear in the Excel file.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT="f"
DIMENSION= ROWS LEVEL = -1
PROCESS = PRECEDING HIDE=TRUE
/STYLES  APPLYTO=BOTH.

The SELECT condition could be a list of row labels, each quoted.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------
#SPSSStatistics

28.0.1.0 (142)

------------------------------
Konrad Gałuszko
------------------------------

Original Message:
Sent: Wed July 20, 2022 10:47 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

What version of Statistics are you using.  That behavior of including the hidden parts but hiding them in Excel was changed several releases ago, though I don't remember the exact version.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 9:03:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

I'm asking about option to not include hidden rows/columns in Excel output. Now, when I run OUTPUT MODIFY data still exist in Excel but are hidden (which is unconvenient while, for example, copying).

------------------------------
Konrad Gałuszko

Original Message:
Sent: Wed July 20, 2022 08:47 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I have no information on that, but the export already excludes hidden parts.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 8:39:00 AM
From: Konrad Gałuszko
Subject: RE: How to delete columns/rows in a custom table which don't meet specified criteria?

Thanks Jon. Will deleting option (in OUTPUT MODIFY) appear in further versions of Statistics?

------------------------------
Konrad Gałuszko

Original Message:
Sent: Wed July 20, 2022 08:34 AM
From: Jon Peck
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

I can't be sure that this works in older versions of Statistics, but this code using SPSSINC MODIFY TABLES hides selected rows, and they do not appear in the Excel file.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT="f"
DIMENSION= ROWS LEVEL = -1
PROCESS = PRECEDING HIDE=TRUE
/STYLES  APPLYTO=BOTH.

The SELECT condition could be a list of row labels, each quoted.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 7/20/2022 7:07:00 AM
From: Konrad Gałuszko
Subject: How to delete columns/rows in a custom table which don't meet specified criteria?

Hello. I'm preparing CTABLES with many divisions both in columns and rows so I need to make tabulations more readable, clear. I would like to delete rows/columns with base less than 30. Since version 27 it's become possible to hide data based on condition using OUTPUT MODIFY. However, when I export those tables to Excel these data still appear and are hidden in rows/columns. Is there any way to totally delete them (via commands, Python extension etc.)?

------------------------------
Konrad Gałuszko
------------------------------
#SPSSStatistics