PCOMPUTE Command in CTABLES
Locked
PCOMPUTE Command in CTABLES
 
|
Hi, I am using PCOMPTE Command in CTABLES. While generating the output it is computing the percentage for new categories also. Is there way that the %age of new category should not be computed? I am attaching the syntax and
output for your reference. CTABLES /VLABELS VARIABLES=rt SEC_A_C01 ct DISPLAY=LABEL /PCOMPUTE &cat1 = EXPR([0]*0 + [5]*5 + [10]*10) /PPROPERTIES &cat1 LABEL = "Achieved Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /PCOMPUTE &cat2 = EXPR([0]*10 + [5]*10 + [10]*10) /PPROPERTIES &cat2 LABEL = "Max Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + SEC_A_C01 [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]] BY ct /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE /CATEGORIES VARIABLES=SEC_A_C01 [0, 5, 10, &cat1, &cat2, OTHERNM] EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE='Sec A Q1' CORNER='Base - All'.
Is there way that red highlighted part should not appear in the output? Only count should be appeared in the case of categories. Thanks Manoj Kantar Disclaimer ===================== 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 |
||||||||||||||||||||||||||||||||||||||||||||||||
|
|
There isn't a way to suppress those statistics directly, but you can use the SPSSINC CENSOR TABLES extension command, which is installed with Statistics in recent versions, to blank out the cells. The code below will blank out the value for any Column N % cells where the value exceeds 100. SPSSINC CENSOR TABLES CRITLABEL="Column N %" TESTTYPE=">" CRITVALUE=100 DIRECTION=column NEIGHBORS=0 PROCESS=LATEST /OPTIONS APPENDCAPTION=NO CONDITIONALCAPTION=YES. On Thu, Feb 18, 2016 at 4:28 AM, Arora, Manoj (IMDLR) <[hidden email]> wrote:
|
||||||||||||||||||||||||||||||||||||||||||||||||
Re: PCOMPUTE Command in CTABLES
|
|
Hi Jon, Thanks for sharing the syntax. I am using SPSS 22 and it showing the following message
I am writing this syntax above the tables like given below SPSSINC CENSOR TABLES CRITLABEL="Column N %" TESTTYPE=">" CRITVALUE=100 DIRECTION=column NEIGHBORS=0 PROCESS=LATEST /OPTIONS APPENDCAPTION=NO CONDITIONALCAPTION=YES. CTABLES /VLABELS VARIABLES=rt SEC_A_C01 ct DISPLAY=LABEL /PCOMPUTE &cat1 = EXPR([0]*0 + [5]*5 + [10]*10) /PPROPERTIES &cat1 LABEL = "Achieved Score" FORMAT=COUNT F40.0, COLPCT.COUNT PCT40.1 HIDESOURCECATS=No /PCOMPUTE &cat2 = EXPR([0]*10 + [5]*10 + [10]*10) /PPROPERTIES &cat2 LABEL = "Max Score" FORMAT=COUNT F40.0, COLPCT.COUNT PCT40.1 HIDESOURCECATS=NO /PCOMPUTE &cat3 = EXPR((([0]*0 + [5]*5 + [10]*10) / ([0]*10 + [5]*10 + [10]*10))*100) /PPROPERTIES &cat3 LABEL = "Index" FORMAT=COUNT F40.0, COLPCT.COUNT PCT40.2 HIDESOURCECATS=NO /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + SEC_A_C01 [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]] BY ct /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE /CATEGORIES VARIABLES=SEC_A_C01 [0, 5, 10, &cat1, &cat2, &cat3, OTHERNM] EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE='AA' CORNER='AA' CAPTION='AA'. Thanks Manoj From: Jon Peck [mailto:[hidden email]]
There isn't a way to suppress those statistics directly, but you can use the SPSSINC CENSOR TABLES extension command, which is installed with Statistics in recent versions, to blank out the cells. The code
below will blank out the value for any Column N % cells where the value exceeds 100. SPSSINC CENSOR TABLES CRITLABEL="Column N %" TESTTYPE=">" CRITVALUE=100 DIRECTION=column NEIGHBORS=0 PROCESS=LATEST /OPTIONS APPENDCAPTION=NO CONDITIONALCAPTION=YES. On Thu, Feb 18, 2016 at 4:28 AM, Arora, Manoj (IMDLR) <[hidden email]> wrote: Hi, I am using PCOMPTE Command in CTABLES. While generating the output it is computing the percentage for new categories also. Is there way that the %age of new category
should not be computed? I am attaching the syntax and output for your reference. CTABLES /VLABELS VARIABLES=rt SEC_A_C01 ct DISPLAY=LABEL /PCOMPUTE &cat1 = EXPR([0]*0 + [5]*5 + [10]*10) /PPROPERTIES &cat1 LABEL = "Achieved Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /PCOMPUTE &cat2 = EXPR([0]*10 + [5]*10 + [10]*10) /PPROPERTIES &cat2 LABEL = "Max Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + SEC_A_C01 [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]] BY ct /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE /CATEGORIES VARIABLES=SEC_A_C01 [0, 5, 10, &cat1, &cat2, OTHERNM] EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE='Sec A Q1' CORNER='Base - All'.
Is there way that red highlighted part should not appear in the output? Only count should be appeared in the case of categories. Thanks Manoj ===================== 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 |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Re: PCOMPUTE Command in CTABLES
|
|
In reply to this post by Jon Peck
Hi Jon, Please find below the syntax and output generated by that SPSSINC CENSOR TABLES command="CTABLES /VLABELS VARIABLES=rt SEC_A_C01 ct DISPLAY=LABEL" " /PCOMPUTE &cat1 = EXPR([0]*0 + [5]*5 + [10]*10)" " /PPROPERTIES &cat1 LABEL = 'Achieved Score' FORMAT=COUNT F40.0, COLPCT.COUNT F40.0 HIDESOURCECATS=No" " /PCOMPUTE &cat2 = EXPR([0]*10 + [5]*10 + [10]*10)" " /PPROPERTIES &cat2 LABEL = 'Max Score' FORMAT=COUNT F40.0, COLPCT.COUNT F40.1 HIDESOURCECATS=NO" " /PCOMPUTE &cat3 = EXPR((([0]*0 + [5]*5 + [10]*10) / ([0]*10 + [5]*10 + [10]*10))*100)" " /PPROPERTIES &cat3 LABEL = 'Index' FORMAT=COUNT F40.0, COLPCT.COUNT PCT40.2 HIDESOURCECATS=NO" " /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + SEC_A_C01 [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]] BY ct + zone" " /SLABELS POSITION=ROW" " /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE" " /CATEGORIES VARIABLES=SEC_A_C01 [0, 5, 10, &cat1, &cat2, &cat3, OTHERNM] EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE" " /TITLES" " TITLE='AA'" " CORNER='AA'" " CAPTION='AA'." CRITLABEL="Column N %" CRITVALUE=100.0 NEIGHBORS=4 DIRECTION=Column, TESTTYPE=">" /OPTIONS HIDECRITFIELD.
It is not generating the desire result. I want to hide the red highlighted rows in the table above. Please let me know where I have done mistake in the syntax above. Regards Manoj From: Jon Peck [mailto:[hidden email]]
There isn't a way to suppress those statistics directly, but you can use the SPSSINC CENSOR TABLES extension command, which is installed with Statistics in recent versions, to blank out the cells. The code
below will blank out the value for any Column N % cells where the value exceeds 100. SPSSINC CENSOR TABLES CRITLABEL="Column N %" TESTTYPE=">" CRITVALUE=100 DIRECTION=column NEIGHBORS=0 PROCESS=LATEST /OPTIONS APPENDCAPTION=NO CONDITIONALCAPTION=YES. On Thu, Feb 18, 2016 at 4:28 AM, Arora, Manoj (IMDLR) <[hidden email]> wrote: Hi, I am using PCOMPTE Command in CTABLES. While generating the output it is computing the percentage for new categories also. Is there way that the %age of new category
should not be computed? I am attaching the syntax and output for your reference. CTABLES /VLABELS VARIABLES=rt SEC_A_C01 ct DISPLAY=LABEL /PCOMPUTE &cat1 = EXPR([0]*0 + [5]*5 + [10]*10) /PPROPERTIES &cat1 LABEL = "Achieved Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /PCOMPUTE &cat2 = EXPR([0]*10 + [5]*10 + [10]*10) /PPROPERTIES &cat2 LABEL = "Max Score" FORMAT=COUNT F40.0 HIDESOURCECATS=NO /TABLE rt [COUNT F40.0, COLPCT.COUNT PCT40.1] + SEC_A_C01 [COUNT F40.0, COLPCT.COUNT PCT40.1, TOTALS[COUNT F40.0]] BY ct /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct ORDER=A KEY=VALUE EMPTY=INCLUDE /CATEGORIES VARIABLES=SEC_A_C01 [0, 5, 10, &cat1, &cat2, OTHERNM] EMPTY=INCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE='Sec A Q1' CORNER='Base - All'.
Is there way that red highlighted part should not appear in the output? Only count should be appeared in the case of categories. Thanks Manoj ===================== 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 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
In reply to this post by Manoj Arora (DEL/Abacus Analytics)
The PROCESS keyword was added in September, 2014. You can install the updated version from the Utilities menu: Extension Commands > Download and Install ... You should start Statistics using Run As Administrator to be sure that it has enough permission to update the files. On Thu, Feb 18, 2016 at 10:21 PM, Arora, Manoj (IMDLR) <[hidden email]> wrote:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
| Free forum by Nabble | Edit this page |