saving .spv with only visible sections retained

[Art Kendall]

Is it possible to save a .spv file with only the visible sections?

Art Kendall
Social Research Consultants
===================== 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

[MaxJasper]

Absolutely. v19

 

Is it possible to save a .spv file with only the visible sections?

Art Kendall
Social Research Consultants

 

[Art Kendall]

any suggestions on how to do that?
If I do <save> or <save as> it save all of the output but when brought back the hidden sections are still there.

I want to be able to send a .spv file to someone who has SmartReader.  I would like them to still work with columns widths etc. in SmartReader.

I know I can manually kill each Notes section by hand one by one.

Art Kendall

Art
On 2/7/2011 1:23 PM, MaxJasper wrote:

Absolutely. v19

 

Is it possible to save a .spv file with only the visible sections?

Art Kendall
Social Research Consultants

 

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

[MaxJasper]

My SPSS 19 keeps hidden sections hidden after closing spv file and reopening them. Might be a setting in Preferences.

 

Max.

 

any suggestions on how to do that?
If I do <save> or <save as> it save all of the output but when brought back the hidden sections are still there.

I want to be able to send a .spv file to someone who has SmartReader.  I would like them to still work with columns widths etc. in SmartReader.

I know I can manually kill each Notes section by hand one by one.

Art Kendall

 

[Jon K Peck]

The MODIFY OUTPUT extension command can delete all items not currently visible.  Here's the syntax.

SPSSINC MODIFY OUTPUT ALL
/IF VISIBILITY=FALSE PROCESS=ALL
/VISIBILITY VISIBLE=DELETE.

The delete option is not supported in the dialog box, since it is more dangerous than the other options in that it can't be reversed.

HTH,

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



From:        Art Kendall <[hidden email]>
To:        [hidden email]
Date:        02/07/2011 11:45 AM
Subject:        Re: [SPSSX-L] saving .spv with only visible sections retained
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

any suggestions on how to do that?
If I do <save> or <save as> it save all of the output but when brought back the hidden sections are still there.

I want to be able to send a .spv file to someone who has SmartReader.  I would like them to still work with columns widths etc. in SmartReader.

I know I can manually kill each Notes section by hand one by one.

Art Kendall

Art
On 2/7/2011 1:23 PM, MaxJasper wrote:
Absolutely. v19


Is it possible to save a .spv file with only the visible sections?

Art Kendall
Social Research Consultants
 
===================== 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]

Maybe I am missing something.

I copied the syntax you posted. I highlighted it and clicked <run All>.
For 35 minutes it has just been sitting there with the words
"running SPSSINC MODIFY OUTPUT" at the bottom of the screen.

The cpu meter shows 0 to 1% cpu usage and 35% of RAM.

Shouldn't Modify Output be a fairly fast process?

I have the .spv file in one window.  4 lines in in the syntax window. (the 3 you posted and an EXECUTE I ran after it was sitting there for 20 minute.) The data window is empty.

On disk the .spv file is 3.48 megabytes.  I have 346 GB free on the hard disk.

Any ideas?

Art



On 2/7/2011 2:02 PM, Jon K Peck wrote:

The MODIFY OUTPUT extension command can delete all items not currently visible.  Here's the syntax.

SPSSINC MODIFY OUTPUT ALL
/IF VISIBILITY=FALSE PROCESS=ALL
/VISIBILITY VISIBLE=DELETE.

The delete option is not supported in the dialog box, since it is more dangerous than the other options in that it can't be reversed.

HTH,

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



From:        Art Kendall [hidden email]
To:        [hidden email]
Date:        02/07/2011 11:45 AM
Subject:        Re: [SPSSX-L] saving .spv with only visible sections retained
Sent by:        "SPSSX(r) Discussion" [hidden email]

---

any suggestions on how to do that?
If I do <save> or <save as> it save all of the output but when brought back the hidden sections are still there.

I want to be able to send a .spv file to someone who has SmartReader.  I would like them to still work with columns widths etc. in SmartReader.

I know I can manually kill each Notes section by hand one by one.

Art Kendall

Art
On 2/7/2011 1:23 PM, MaxJasper wrote:
Absolutely. v19


Is it possible to save a .spv file with only the visible sections?

Art Kendall
Social Research Consultants
 
===================== 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

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

[lucameyer]

I confirm the SPSS MODIFY OUTPUT is reasonably fast. I have just tested it on a 3,7 MB spv output file - btw generated when I still had v18 installed - using a MacBook Pro (Intel 2.4 Ghz, 4 GB RAM) and V19.0.0.1 and I have got it modified in 30 seconds.

So something must be wrong with your settings, can you easily run other extension commands?

Cheers,
Luca

[Art Kendall]

With Jon Peck's help I have gotten MODIFY OUTPUT working.

The first thing in the fix was  that I uninstalled the SPSS statistics Python Essentials and reinstalled it.  The syntax then worked. It was very fast.

I  learned that MODIFY OUTPUT works on .spv files that have been read back in (unlike MODIFY TABLES which I mentioned in an earlier post this morning).

I learned that if you want to delete whole groups of itemtypes you can set them as hidden BEFORE the run by
<edit> <options> <viewer>
OR
you can hide or make visible very specific index entries by clicking on the little icon in the index until it says
 "hidden" or "visible" in the bar at the bottom left of the output screen.  The last segment in the example syntax  will delete only hidden index entries.

There is syntax below that demonstrates some output clean up syntax.  I suggest that you highlight segments and run them one at a time to see what they do.

Art Kendall
Social Research Consultants

GET
  FILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\carpet.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.

FREQUENCIES VARIABLES= package brand
  /ORDER=ANALYSIS.
FREQUENCIES VARIABLES=brand price
  /ORDER=ANALYSIS.
FREQUENCIES VARIABLES= seal price
  /ORDER=ANALYSIS.

* these work with SPV files that are read back into SPSS.
SPSSINC MODIFY OUTPUT ALL
/IF OUTLINETITLE= "Active Dataset"
PROCESS=ALL
/VISIBILITY VISIBLE=DELETE.

SPSSINC MODIFY OUTPUT ALL
/IF OUTLINETITLE= "notes"
PROCESS= ALL
/VISIBILITY VISIBLE=DELETE.

SPSSINC MODIFY OUTPUT ALL
/IF OUTLINETITLE= "WARNINGS"
PROCESS= ALL
/VISIBILITY VISIBLE=DELETE.

**** CAREFUL **** .
* This cleaned out the "statistics" from FREQUENCIES but not "descriptive statistics" from DESCRIPTIVES.
* I would double check how this works from other procedures before using it..
SPSSINC MODIFY OUTPUT ALL
/IF OUTLINETITLE= "STATISTICS"
PROCESS= ALL
/VISIBILITY VISIBLE=DELETE.

*if you want to delete whole groups of itemtypes you can set them as hidden BEFORE the run by
<edit> <options> <viewer>
OR
you can hide very specific things by clicking on the little icon in the index until it says
 "hidden" in bar at the bottom left of the screen.
*****  This can be very dangerous *****.
SPSSINC MODIFY OUTPUT ALL
/IF VISIBILITY=FALSE PROCESS=ALL
/VISIBILITY VISIBLE=DELETE.









On 2/9/2011 4:53 AM, lucameyer wrote:

I confirm the SPSS MODIFY OUTPUT is reasonably fast. I have just tested it on
a 3,7 MB spv output file - btw generated when I still had v18 installed -
using a MacBook Pro (Intel 2.4 Ghz, 4 GB RAM) and V19.0.0.1 and I have got
it modified in 30 seconds.

So something must be wrong with your settings, can you easily run other
extension commands?

Cheers,
Luca

-----
Mr. Luca Meyer
www.lucameyer.com
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/saving-spv-with-only-visible-sections-retained-tp3374699p3377315.html
Sent from the SPSSX Discussion mailing list archive at 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

===================== 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 your example, what is the general term for the level of the outline that says "Custom Tables" or "Regression"?

The person I am working with is from Korea and Roman numerals like this: Table dccclxxxv: Statistics
would be very difficult. 50 years ago I was very good at arithmetic with roman numerals, but I had to think to decode that as table  885, ( what I received when I ran your example).

How would I have the bookmarks either refer
or
1) just to the higher level of the outline, "Custom Tables" or "Regression",
1
    table ...
    table ...
2
    table ...
--- OR --
2) have Arabic numerals for the higher level, and lower case letters for the individual tables, with the letters starting over with "a" within each of the higher levels?
1
    table a ...
    table b ...
2
    table a ...
--- OR --
3) have Arabic numbers from 1 to 885.
    table 1 ...
    table  2...

    table 885 ...

I have some reflections on
>>>I am sometimes astonished at the ratio of doing analysis to prepping the output that I hear about.
that I'll try to send tomorrow.

Art Kendall
Social Research Consultants


On 2/9/2011 1:19 PM, Jon K Peck wrote:

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



From:        Art Kendall [hidden email]
To:        Jon K Peck/Chicago/IBM@IBMUS
Date:        02/09/2011 10:10 AM
Subject:        Re: [SPSSX-L] saving .spv with only visible sections retained

---

Thanks I am getting clearer on this and it looks like these will be very useful extensions.
>>>I am sometimes astonished at the ratio of doing analysis to prepping the output that I hear about.

One extension I was thinking about is this.
When I output to paper, WORD,  or .pdf there are page numbers that can be used a "book marks" to facilitate conversation.

However sending a .SPV file allows some modification (column width, wrapping, etc.) by the person on the receiving end.

I believe it is possible to set specific page breaks one at a time.  Is there a way to globally create some "book marks" to index entries that remain after cleaning out  material that is extraneous for the receiver?
Then all  both I and the receiver would have to do is something like  <edit> <find> "bookmark 231".

>>>I'm not sure exactly what you want here, but there are a few things you can do already.
- MODIFY OUTPUT can insert page breaks before the items you select.  So you could, for example, automatically insert a page break before every table or every table with an outline title of "Descriptives" or any other selection criteria.
- MODIFY OUTPUT can sequence number items - even with roman numerals if you want.  So you could sequence number every item or perhaps just every table and then use that for searching.  Here's an example.  This example replaces all outline titles for tables with the text
Table xxx: the old title
where xxx is a sequential roman numeral. \\1 stands for the old text; \\0 stands for the sequence number.

SPSSINC MODIFY OUTPUT TABLES
/IF PROCESS=ALL
/REPLACE ITEMS OUTLINETITLE= "Table \\0: \\1"
SEQUENCETYPE=ROMANLOWER.

This is the result.

<snip>

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