How to output tables when all values are 0

Posted by Nancy Rusinak-2 on
URL: http://spssx-discussion.165.s1.nabble.com/How-to-output-tables-when-all-values-are-0-tp5740599.html

Hello,

My company has asked me to put together an Excel report that is easily refreshed weekly.  I have syntax to calculate and output a table for new hires for 2 specific areas. Some weeks there are no new hires. My ctables syntax leads to this output: “No cases were input to this procedure.  Either there are no cases in the working data file or all of them have been filtered out.”

I export my output to a worksheet in the Excel report.  The report charts reference cells my spss output so I’d like to have “0” in the appropriate cell when there are no new hires.  Would there be a way to have my output produce a table where the column heading is “Count” and there are two rows (for my two areas) with both containing a “0” when there are no new hires?

I’ve tried using the subcommand /FORMAT EMPTY=ZERO MISSING=‘.0’ but that isn’t getting me there.

Much thanks, all.

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