Hello everyone,

is there a syntax or syntax part I can paste into my existing syntax so that my output values ​​such as the means are shown without decimals and the values ​​of a frequency table with % signs? So that I don't always have to do this individually and manually in the output file?

Example:


FREQUENCIES VARIABLES= var1
var2
var3
var4
/FORMAT=DVALUE
 /STATISTICS=MEAN 
 /ORDER= ANALYSIS.

MEANS
TABLES 
var1
var2
var3
var4
/CELLS Mean Count Semean.
--> How and where do I have to include the formatting part?

Thanks very much!

------------------------------
Samantha Weigt
------------------------------

Hi. I have good news, and I have bad news.

The GOOD news is that you are asking about the OUTPUT MODIFY command.

The BAD news is that you are asking about the OUTPUT MODIFY command.

It is a very powerful but also difficult command to master. I have given you an example here...

output close all.
dataset close all.
data list free /var1 to var4 (4F6.2).
begin data.
1 2 3 4
1.1 2.2 3.3 4.4
1.12 2.24 3.34 4.46
end data.

FREQUENCIES VARIABLES= var1 var2 var3 var4
 /FORMAT=DVALUE /STATISTICS=MEAN /ORDER= ANALYSIS.

OUTPUT MODIFY
  /REPORT PRINTREPORT=NO
  /SELECT TABLES
  /IF SUBTYPES=['Statistics']
  /TABLECELLS SELECT=[MEAN] SELECTDIMENSION=BOTH
   SELECTCONDITION=ALL FORMAT="F.0" APPLYTO=ROW.

There is a wizard you can follow to try and help you put together the OUTPUT MODIFY you want. First, run your FREQUENCY. Then, in the Output Window, select the table you want to modify, using the tree view (left pane):

Select Modify Output > Launch Wizard

Continue

Conditional Styling

Value> Choose Mean

Dimension> Rows

Format > Click the ellipsis [...]

Make it look like the above, then Continue > Continue > Paste

Look at your syntax window. Mine looks like this:

Run that. Check the Statistics table from Frequencies; the means should have changed format to 0 decimals.

***.

This is one example. You can use OUTPUT MODIFY to do A LOT of things; that is it's strength, and what makes it hard to use. Experiment a little with it, and see if you can use it to format your output the way you want it.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------