Format FREQUENCIES output

[Moon Kid]

If there is any way to all it by script/syntax please tell me. But I
think it is not, so I try to deal with the SPSS-possibilities.

I do a simple
FREQUENCIES VARIABLES=v41 v42
  /STATISTICS=DEFAULT
  /ORDER=ANALYSIS.

That create three tables in my output window. There is to much
information. I don't need the first statistics-table. I don't need
cumulative percent and so on...

I know I can right click on it and edit the table in a extra editor
window. Kind of nice.
In that editor I don't change fonts, colors or things like that. I
change the content, what means that I kill some rows and/or columns or
modify some Heading-Strings.

But what I now want is to save(!) the optical modifications I have done
on the outputed tables. Maybe when there is some new data, etc I have
to execute my analyse-script/syntax (e.g. the FREQENCIES on top of that
posting) again. In that case I don't want to edited each outputed table
again. I want SPSS to remember how I like my tables. ;)
Is there a way for that?

=====================
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]

There are several tools available to automate this process.
First, you can use OMS to suppress any output items you want to eliminate from the Viewer.  For example,
OMS SELECT ALL /EXCEPTIF  SUBTYPES='Frequencies'
/DESTINATION VIEWER=NO.
FREQUENCIES VARIABLES=educ
  /ORDER=ANALYSIS.
OMSEND.

Second, you can use the built-in OUTPUT MODIFY command if you have Statistics V22 to apply various style modifications to the tables.
With earlier versions or if OUTPUT MODIFY doesn't do what you want, you can use the SPSSINC MODIFY TABLES extension command to do more things, including hiding selected columns.

Do all this before you save the Viewer file or export it to other formats with OUTPUT EXPORT.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        03/29/2014 10:36 AM
Subject:        [SPSSX-L] Format FREQUENCIES output
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

If there is any way to all it by script/syntax please tell me. But I
think it is not, so I try to deal with the SPSS-possibilities.

I do a simple
FREQUENCIES VARIABLES=v41 v42
 /STATISTICS=DEFAULT
 /ORDER=ANALYSIS.

That create three tables in my output window. There is to much
information. I don't need the first statistics-table. I don't need
cumulative percent and so on...

I know I can right click on it and edit the table in a extra editor
window. Kind of nice.
In that editor I don't change fonts, colors or things like that. I
change the content, what means that I kill some rows and/or columns or
modify some Heading-Strings.

But what I now want is to save(!) the optical modifications I have done
on the outputed tables. Maybe when there is some new data, etc I have
to execute my analyse-script/syntax (e.g. the FREQENCIES on top of that
posting) again. In that case I don't want to edited each outputed table
again. I want SPSS to remember how I like my tables. ;)
Is there a way for that?

=====================
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

[Moon Kid]

I am not sure if I understand you right.

Just for being clear: In my example I want to exclude the rows
"Cumulative Percent" and "Valid Percent" from the output. I don't want
to see them. ;)

On 2014-03-29 10:48 Jon K Peck <[hidden email]> wrote:
> There are several tools available to automate this process.
> First, you can use OMS to suppress any output items you want to
> eliminate from the Viewer.  For example,
> OMS SELECT ALL /EXCEPTIF  SUBTYPES='Frequencies'
> /DESTINATION VIEWER=NO.
> FREQUENCIES VARIABLES=educ
>   /ORDER=ANALYSIS.
> OMSEND.

I can see how this suppress the first output table. I found DIMNAMES.
But I am not sure if this could help me.
OMS SELECT ALL
 /COLUMNS DIMNAMES = ['Cumulative Percent'].
FREQUENCIES VARIABLES=v42
   /ORDER=ANALYSIS.
OMSEND.

> Second, you can use the built-in OUTPUT MODIFY command if you have
> Statistics V22

Mhm... I will check that. Maybe it is more my way...

> SPSSINC MODIFY TABLES extension

I am not aware with SPSS extensions. How do I recieve them. There is no
dialog or help entry about in the SPSS gui. On the web I found only a
lot of support postings about SPSSINC MODIFY TABLES but not where it
comes from.
--
<http://dontbubble.us/>

=====================
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

[Moon Kid]

On 2014-03-29 10:48 Jon K Peck <[hidden email]> wrote:
> Second, you can use the built-in OUTPUT MODIFY command if you have

Mhm... This doesn't really work. It delete the complete table. Maybe it
is not possible to select a row as an "object" in the meaning of OUTPUT
MODIFY?

OUTPUT MODIFY
   /SELECT ALL
   /DELETEOBJECT DELETE = YES.

FREQUENCIES VARIABLES=v42
   /ORDER=ANALYSIS.

OUTPUT MODIFY
   /REPORT PRINTREPORT=YES
   /SELECT TABLES /IF SUBTYPES=['Frequencies']
   /TABLECELLS
     SELECT=["Cumulative Percent"]
     SELECTDIMENSION=COLUMNS
   /DELETEOBJECT DELETE = YES.

=====================
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

[Art Kendall]

In frequencies aren't the percents in columns?
On 3/29/2014 2:26 PM, Moon Kid [via SPSSX Discussion] wrote:

On 2014-03-29 10:48 Jon K Peck <[hidden email]> wrote:
> Second, you can use the built-in OUTPUT MODIFY command if you have

Mhm... This doesn't really work. It delete the complete table. Maybe it
is not possible to select a row as an "object" in the meaning of OUTPUT
MODIFY?

OUTPUT MODIFY
   /SELECT ALL
   /DELETEOBJECT DELETE = YES.

FREQUENCIES VARIABLES=v42
   /ORDER=ANALYSIS.

OUTPUT MODIFY
   /REPORT PRINTREPORT=YES
   /SELECT TABLES /IF SUBTYPES=['Frequencies']
   /TABLECELLS
     SELECT=["Cumulative Percent"]
     SELECTDIMENSION=COLUMNS
   /DELETEOBJECT DELETE = YES.

=====================
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

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Format-FREQUENCIES-output-tp5725090p5725096.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML

[Jon K Peck]

You mean columns.  Here is an example using MODIFY TABLES to suppress those columns.

FREQUENCIES VARIABLES=educ
  /ORDER=ANALYSIS.

SPSSINC MODIFY TABLES subtype="'Frequencies'"
SELECT=2 3  HIDE=TRUE.

Explanation:
This works on the immediately preceding command output.  It selects the third and fourth columns - they are numbered from 0,
and applies the HIDE action to them.  There are lots of other options for this command.

Apparently you have Statistics V22.  When you installed it, unless you chose a nondefault option, you installed the Python Essentials.  That includes some of the available extension commands, but there are many more.  Use Utilities > Extension Bundles > Download and Install Extension Bundles to see the list.  Check the boxes for the ones you want, and it will download and install these.

You can also visit the SPSS Community website (www.ibm.com/developerworks/spssdevcentral) and follow the Downloads for SPSS Statistics link and then you will see various collections of tools and utilities, including the Extension Commands collection, but you do not need to visit that page as long as you have V22.

Extension commands are commands that have standard Statistics style syntax as in the above example and usually a dialog box interface but that are implemented in Python, R, or Java and operate through their respective plugin.  Currently there are about 94 of these in the collection, and more are in the works.

OMS works on whole items, so it can't hide columns, but I suggested it to hide the other output  objects you didn't want.

HTH,

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        03/29/2014 11:46 AM
Subject:        Re: [SPSSX-L] Format FREQUENCIES output
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I am not sure if I understand you right.

Just for being clear: In my example I want to exclude the rows
"Cumulative Percent" and "Valid Percent" from the output. I don't want
to see them. ;)

On 2014-03-29 10:48 Jon K Peck <[hidden email]> wrote:
> There are several tools available to automate this process.
> First, you can use OMS to suppress any output items you want to
> eliminate from the Viewer.  For example,
> OMS SELECT ALL /EXCEPTIF  SUBTYPES='Frequencies'
> /DESTINATION VIEWER=NO.
> FREQUENCIES VARIABLES=educ
>   /ORDER=ANALYSIS.
> OMSEND.

I can see how this suppress the first output table. I found DIMNAMES.
But I am not sure if this could help me.
OMS SELECT ALL
/COLUMNS DIMNAMES = ['Cumulative Percent'].
FREQUENCIES VARIABLES=v42
  /ORDER=ANALYSIS.
OMSEND.

> Second, you can use the built-in OUTPUT MODIFY command if you have
> Statistics V22

Mhm... I will check that. Maybe it is more my way...

> SPSSINC MODIFY TABLES extension

I am not aware with SPSS extensions. How do I recieve them. There is no
dialog or help entry about in the SPSS gui. On the web I found only a
lot of support postings about SPSSINC MODIFY TABLES but not where it
comes from.
--
<http://dontbubble.us/>

=====================
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

[Moon Kid]

On 2014-03-29 12:01 Art Kendall <[hidden email]> wrote:
> In frequencies aren't the percents in columns?

Yes, of course. My fault.
--
<http://dontbubble.us/>

=====================
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

[Moon Kid]

On 2014-03-29 16:38 Jon K Peck <[hidden email]> wrote:
> Here is an example using MODIFY TABLES to suppress
> those columns.

Great! ;) Thank you very much.

But how can I find the documentation about the extensions? In the
extensions folder is nothing like "SPSSINC MODIFY*". The extension
folder of the AppData just hold some html-files about the Dialog but
not the syntax.
--
<http://dontbubble.us/>

=====================
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]

Most extensions have a dialog box with help.  Also running the command with a HELP subcommand will show the syntax, e.g.,
SPSSINC MODIFY /HELP.  Utilities > Extension Bundles > View Installed Extension Bundles will show information about each installed bundle, including its menu location.

In some cases looking at the source file(s) has more examples and details.  To find where the code is installed, run
SHOW EXT.
That lists the directories that Statistics searches for these commands.  The first hit is the one it uses.  The actual locations vary over operating systems, user configuration, and Statistics releases.

There is a document in the Books & Articles section of the SPSS Community website (www.ibm.com/developerworks/spssdevcentral) that lists all the IBM-developed extensions with a brief summary of what each one does.  The newest ones might not be in that document, since it is not updated every time a new command is added, but the Download and Install Extension Bundles display is always up to date (within an hour or so).


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        03/30/2014 05:54 AM
Subject:        Re: [SPSSX-L] Format FREQUENCIES output
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

On 2014-03-29 16:38 Jon K Peck <[hidden email]> wrote:
> Here is an example using MODIFY TABLES to suppress
> those columns.

Great! ;) Thank you very much.

But how can I find the documentation about the extensions? In the
extensions folder is nothing like "SPSSINC MODIFY*". The extension
folder of the AppData just hold some html-files about the Dialog but
not the syntax.
--
<http://dontbubble.us/>

=====================
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]

The help example below should have been
SPSSINC MODIFY TABLES /HELP.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Jon K Peck/Chicago/IBM@IBMUS
To:        [hidden email],
Date:        03/30/2014 07:16 AM
Subject:        Re: [SPSSX-L] Format FREQUENCIES output
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Most extensions have a dialog box with help.  Also running the command with a HELP subcommand will show the syntax, e.g.,
SPSSINC MODIFY /HELP.  Utilities > Extension Bundles > View Installed Extension Bundles will show information about each installed bundle, including its menu location.

In some cases looking at the source file(s) has more examples and details.  To find where the code is installed, run
SHOW EXT.
That lists the directories that Statistics searches for these commands.  The first hit is the one it uses.  The actual locations vary over operating systems, user configuration, and Statistics releases.

There is a document in the Books & Articles section of the SPSS Community website (www.ibm.com/developerworks/spssdevcentral) that lists all the IBM-developed extensions with a brief summary of what each one does.  The newest ones might not be in that document, since it is not updated every time a new command is added, but the Download and Install Extension Bundles display is always up to date (within an hour or so).


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Moon Kid <[hidden email]>
To:        [hidden email],
Date:        03/30/2014 05:54 AM
Subject:        Re: [SPSSX-L] Format FREQUENCIES output
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

On 2014-03-29 16:38 Jon K Peck <[hidden email]> wrote:
> Here is an example using MODIFY TABLES to suppress
> those columns.

Great! ;) Thank you very much.

But how can I find the documentation about the extensions? In the
extensions folder is nothing like "SPSSINC MODIFY*". The extension
folder of the AppData just hold some html-files about the Dialog but
not the syntax.
--
<http://dontbubble.us/>

=====================
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