Can one influence the output format for Case Summaries

[Mark Webb-5]

I want to pad the blank cells in Case Summary output.
An example possible best way to explain.

Summarizing sales by category and retail site.
Output something like -

Category       RetailSite   Sales_Sum
Beverages          1                 1234
                           2                  2345
                           3                  3456
Confectionery     1                  4567
                            2                 5678  
                            3                 7890
Note that the categories are not repeated for each line.
I want to take the results of the Case Summaries into Excel and then to MySQL as a table.
So I need the category column to be padded with data.
Any suggestions how this can be achieved?

Regards

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

[Mark Webb-5]

I have solved this issue.
Write results to an external file does it.
Regards

-------- Forwarded Message --------

Subject:	Can one influence the output format for Case Summaries
Date:	Mon, 25 May 2015 06:15:28 +0200
From:	Mark Webb [hidden email]
To:	[hidden email] [hidden email]

I want to pad the blank cells in Case Summary output.
An example possible best way to explain.

Summarizing sales by category and retail site.
Output something like -

Category       RetailSite   Sales_Sum
Beverages          1                 1234
                           2                  2345
                           3                  3456
Confectionery     1                  4567
                            2                 5678  
                            3                 7890
Note that the categories are not repeated for each line.
I want to take the results of the Case Summaries into Excel and then to MySQL as a table.
So I need the category column to be padded with data.
Any suggestions how this can be achieved?

Regards

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

[David Marso]

OMS + LAG?
-----------------

Mark Webb-5 wrote

I have solved this issue.
Write results to an external file does it.
Regards

Mark Webb

Line [phone]
Cell [phone] [Poor reception]
Fax  [phone]

Skype       tomarkwebb
Email       [hidden email]



-------- Forwarded Message --------
Subject: Can one influence the output format for Case Summaries
Date: Mon, 25 May 2015 06:15:28 +0200
From: Mark Webb <[hidden email]>
To: [hidden email] <[hidden email]>



I want to pad the blank cells in Case Summary output.
An example possible best way to explain.

Summarizing sales by category and retail site.
Output something like -

Category       RetailSite   Sales_Sum
Beverages          1                 1234
                            2                  2345
                            3                  3456
Confectionery     1                  4567
                             2                 5678
                             3                 7890
Note that the categories are not repeated for each line.
I want to take the results of the Case Summaries into Excel and then to
MySQL as a table.
So I need the category column to be padded with data.
Any suggestions how this can be achieved?

Regards

--
Mark Webb

Line [phone]
Cell [phone] [Poor reception]
Fax  [phone]

Skype       tomarkwebb
[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