spssinc modify tables - deleting rows

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

spssinc modify tables - deleting rows

jagadishpchary
This post was updated on .
Hi,

I am using the below syntax in spss to delete some rows in the tables (column proportions table as well).
unfortunately i tried to modify the code but noluck.

spssinc modify tables subtype="custom table" Select ="L2B" dimension=rows
level=-2 process=preceding hide=true.


Could anyone please help me in correcting the code.

Attached the required table format in the attached excel report i.e.
table-2.
Book4.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Book4.xlsx

Also attached the spss data file.
data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data.sav

thanks for the help.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: spssinc modify tables - deleting rows

Jon Peck
The level parameter should be -1 since you are hiding the rows with the innermost specified label.

On Sat, Nov 23, 2019 at 8:49 AM jagadishpchary <[hidden email]> wrote:
Hi,

I am using the below syntax in spss to delete some rows in the table.
unfortunately i tried to modify the code but noluck.

spssinc modify tables subtype="custom table" Select ="L2B" dimension=rows
level=-2 process=preceding hide=true.


Could anyone please help me in correcting the code.

Attached the required table format in the attached excel report i.e.
table-2.
Book4.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/Book4.xlsx

Also attached the spss data file.
data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t340698/data.sav

thanks for the help.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD


--
Jon K Peck
[hidden email]

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: spssinc modify tables - deleting rows

jagadishpchary
Hi Jon,

thanks for the reply.

I was unable to delete the mentioned raw in the main table by using -1. it
is getting deleted in the column proportions table only.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: spssinc modify tables - deleting rows

Jon Peck
That means that you are specifying the wrong table type to SPSSINC MODIFY TABLES.  The main table has a type of "customtable" while the column proportions type is 'Comparisons of Proportions'

On Mon, Nov 25, 2019 at 12:25 AM jagadishpchary <[hidden email]> wrote:
Hi Jon,

thanks for the reply.

I was unable to delete the mentioned raw in the main table by using -1. it
is getting deleted in the column proportions table only.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD


--
Jon K Peck
[hidden email]

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: spssinc modify tables - deleting rows

jagadishpchary
Hi Jon,

As said, i have used the below syntax. however the issue is not resolved.
May i know where i am going wrong?

spssinc modify tables subtype="customtable" Select ="L2B" dimension=rows
level=-1 process=preceding hide=true.
spssinc modify tables subtype="Comparisons of Proportions" Select ="L2B"
dimension=rows level=-1 process=preceding hide=true.

Regards,
Jagadish



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD