I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole
------------------------------

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole
------------------------------

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Yes, I understood, but for some reason I can't replicate it. (I'm on a Mac with version 29.)

In a syntax window, issue the command:
SET PRINTBACK ON.

then in the menus, do your selection in the menu to filter cases, and select OK. I'd like to see what syntax is pasted, so I can make sure I'm doing the same thing you are.

Mine looks like this:

USE ALL.
COMPUTE filter_$=(VAR00001=1).
VARIABLE LABELS filter_$ 'VAR00001=1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Mon November 07, 2022 11:12 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

Yes, I have the same syntax:
USE ALL.
COMPUTE filter_$=(VAR00001 = 1).
VARIABLE LABELS filter_$ 'VAR00001 = 1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


------------------------------
Jennifer Cole
------------------------------

Original Message:
Sent: Mon November 07, 2022 11:21 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I understood, but for some reason I can't replicate it. (I'm on a Mac with version 29.)

In a syntax window, issue the command:
SET PRINTBACK ON.

then in the menus, do your selection in the menu to filter cases, and select OK. I'd like to see what syntax is pasted, so I can make sure I'm doing the same thing you are.

Mine looks like this:

USE ALL.
COMPUTE filter_$=(VAR00001=1).
VARIABLE LABELS filter_$ 'VAR00001=1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:12 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics

If you're on Windows, could you please open a command window, cd into the SPSS installation directory, and start SPSS using spss.com? Then, do whatever actions you have been doing to see the error. When it fails look at the command window and see if anything was written to it by SPSS. If we wrote something, please copy it and paste it into a response so we can get some idea what's going wrong.

(If you're on Mac, then open a console window, cd into "/Applications/IBM SPSS Statistics 27/SPSS Statistics.app/Contents/MacOS", and start with ./stats)

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Mon November 07, 2022 11:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I have the same syntax:
USE ALL.
COMPUTE filter_$=(VAR00001 = 1).
VARIABLE LABELS filter_$ 'VAR00001 = 1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 11:21 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I understood, but for some reason I can't replicate it. (I'm on a Mac with version 29.)

In a syntax window, issue the command:
SET PRINTBACK ON.

then in the menus, do your selection in the menu to filter cases, and select OK. I'd like to see what syntax is pasted, so I can make sure I'm doing the same thing you are.

Mine looks like this:

USE ALL.
COMPUTE filter_$=(VAR00001=1).
VARIABLE LABELS filter_$ 'VAR00001=1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:12 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------
#SPSSStatistics

I wish it was that easy at my institution. I had to get my department IT person to remote access my computer to try to change the directory in the command prompt (using Windows) because my institution doesn't allow users administrative rights.

Could you please provide the specific command? We looked up the directory online and no permutation of it worked. We just kept getting the message that the system could not find the path specified.

------------------------------
Jennifer Cole
------------------------------

Original Message:
Sent: Mon November 07, 2022 03:23 PM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

If you're on Windows, could you please open a command window, cd into the SPSS installation directory, and start SPSS using spss.com? Then, do whatever actions you have been doing to see the error. When it fails look at the command window and see if anything was written to it by SPSS. If we wrote something, please copy it and paste it into a response so we can get some idea what's going wrong.

(If you're on Mac, then open a console window, cd into "/Applications/IBM SPSS Statistics 27/SPSS Statistics.app/Contents/MacOS", and start with ./stats)

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I have the same syntax:
USE ALL.
COMPUTE filter_$=(VAR00001 = 1).
VARIABLE LABELS filter_$ 'VAR00001 = 1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 11:21 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I understood, but for some reason I can't replicate it. (I'm on a Mac with version 29.)

In a syntax window, issue the command:
SET PRINTBACK ON.

then in the menus, do your selection in the menu to filter cases, and select OK. I'd like to see what syntax is pasted, so I can make sure I'm doing the same thing you are.

Mine looks like this:

USE ALL.
COMPUTE filter_$=(VAR00001=1).
VARIABLE LABELS filter_$ 'VAR00001=1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:12 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------
#SPSSStatistics

Start SPSS.
In a syntax window, enter this command:

SHOW ENV.

and see what the value of SPSS_HOME is.

Either you or - if you cannot for any reason - open a command window and use the CD command to change directories to whatever the path for SPSS_HOME is. That is where you would type spss.com, then press <Enter>.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Tue November 08, 2022 03:45 PM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I wish it was that easy at my institution. I had to get my department IT person to remote access my computer to try to change the directory in the command prompt (using Windows) because my institution doesn't allow users administrative rights.

Could you please provide the specific command? We looked up the directory online and no permutation of it worked. We just kept getting the message that the system could not find the path specified.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 03:23 PM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

If you're on Windows, could you please open a command window, cd into the SPSS installation directory, and start SPSS using spss.com? Then, do whatever actions you have been doing to see the error. When it fails look at the command window and see if anything was written to it by SPSS. If we wrote something, please copy it and paste it into a response so we can get some idea what's going wrong.

(If you're on Mac, then open a console window, cd into "/Applications/IBM SPSS Statistics 27/SPSS Statistics.app/Contents/MacOS", and start with ./stats)

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I have the same syntax:
USE ALL.
COMPUTE filter_$=(VAR00001 = 1).
VARIABLE LABELS filter_$ 'VAR00001 = 1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 11:21 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Yes, I understood, but for some reason I can't replicate it. (I'm on a Mac with version 29.)

In a syntax window, issue the command:
SET PRINTBACK ON.

then in the menus, do your selection in the menu to filter cases, and select OK. I'd like to see what syntax is pasted, so I can make sure I'm doing the same thing you are.

Mine looks like this:

USE ALL.
COMPUTE filter_$=(VAR00001=1).
VARIABLE LABELS filter_$ 'VAR00001=1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 11:12 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thanks, Rick.

When I carry out the Data Select IF in the dialogue box, it seems to have passed through: the data editor states, "Filter On." The frustrating problem is I cannot change values in cells once I have data selected. In versions of SPSS Statistics before 26, I could change values in cells while I had cases selected using Data Select IF.

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:36 AM
From: Rick Marcantonio
Subject: Cannot change values in cells while I have cases filtered with Select IF

Look at the bottom status bar of the Data Editor. If you see:


then go to the Transform menu and select "Run pending transforms," which is really just the same as typing 

EXECUTE.

in a syntax windows and running it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Mon November 07, 2022 10:31 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------
#SPSSStatistics

Original Message:
Sent: 11/7/2022 10:32:00 AM
From: Jennifer Cole
Subject: RE: Cannot change values in cells while I have cases filtered with Select IF

Thank you for your prompt reply. I should have mentioned that this is a situation we are encountering using the point and click dialogue boxes, not while running syntax. In this case do you know how I would make sure the data have passed after I select the cases using the dialogue box?

------------------------------
Jennifer Cole
------------------------------

Original Message:
Sent: Mon November 07, 2022 10:21 AM
From: Jon Peck
Subject: Cannot change values in cells while I have cases filtered with Select IF

Are you getting the Data changes are not permitted message?  If you have executed SELECT IF but have not actually passed the data, the DE cannot change cases.

In your older version you might have had the preferences set to pass the data automatically after a transformation has been submitted, so you didn't see this.

But you can just run an EXECUTE command or any procedure to pass the data and allow changes to be made in the DE.

V27, iirc, also had a change to how selected cases were displayed, so it might look like the data have been passed, because the slashed case numbers didn't necessarily appear.

--

Jon K Peck
jkpeck@gmail.com

Original Message:
Sent: 11/7/2022 9:20:00 AM
From: Jennifer Cole
Subject: Cannot change values in cells while I have cases filtered with Select IF

I have searched the forum and IBM Community Home for entries about a problem a colleague and I are having with SPSS 27. I have worked with SPSS for 24 years and in SPSS 26 and 27 I have been unable to execute a simple function that was part of earlier versions of SPSS. The problem is when I have data selected (Select if….) to filter in/out specific cases, then I cannot make any changes to the data. I cannot change values in cells manually. Is there a default setting I need to change to restore this function in SPSS 27? I do not understand why SPSS Statistics would have made this change and decreased the program's functionality.

Thank you for any guidance and help.

------------------------------
Jennifer Cole
------------------------------

#SPSSStatistics