is there a way to makke empy rows in SPSS 18?

[la volta statistics]

Hi all,

 

I would like to include an empty row in a table after each category.

The code below worked for SPSS 15.

Unfortunately, SPSS 18 adds the numbers into the data cells.

Is there different way to have empty rows in tables using SPSS 18?

Thanks in advance

Christian

 

 

New File

Dataset Close All.

data list list

 /Medi(F8.0) Sex(F8.1) Age(F8.2) .

begin data

1 1 44.25

2 1 52.92

1 1 37.21

1 1 60.87

2 1 58.69

2 2 43.17

1 2 44.93

1 1 34.19

1 2 39.96

2 1 63.04

End Data.

 

Var Label Medi 'Treatment'.

Val Label Medi 1 'Verum'

               2 'Placebo'.

 

Var Label Sex "Gender".

Val Label Sex 1 "male"

              2 "female".

*Missing Values Sex (2).

 

Compute Pat = 1.

Var Label Pat "Total".

VaL Label Pat 1 " ".

 

Compute Spacer = 0.

Var Label Spacer ' '.

Val LAbel Spacer 1 ' '.

*Missing Values Spacer (0).

*RECODE Spacer (else = sysmiss).

 

CTABLES

 /FORMAT EMPTY = " " MISSING = "X "

 /VLABELS VARIABLES=Medi sex Age DISPLAY=DEFAULT

 /SMISSING VARIABLE

 /TABLE Pat [c] [Count " " F8.0]                          +

     Spacer [C] [Count " " ]                              +

        sex [C] [COUNT "N" F8.0, COLPCT.COUNT "%" PCT8.1] +

     Spacer [c] [Count " " ]                              +

       Age  [s]  [VALIDN "Valid" F8.0,

                 MEAN "Mean" F8.2,

                 MAXIMUM "Maximum" F8.2,

                 MINIMUM "Minimum" F8.2,

                 MEDIAN "Median" F8.2,

                 STDDEV "Std.dev." F8.2,

                 PTILE 25 "Percentile 25" F8.2,

                 PTILE 75 "Percentile 75" F8.2]

    BY Medi [c]

 /Titles TITLE = "My Table 1"

 /SLABELS POSITION=Row

 /CATEGORIES VARIABLES = Medi ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER

 /CATEGORIES VARIABLES = Spacer [1] EMPTY=INCLUDE

 /CATEGORIES VARIABLES=sex ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING = Exclude.

 

 

**********************************
la volta statistics

Christian Schmidhauser, Dr.phil.II
Weinbergstrasse 108
CH-8006 Zürich
Tel: [phone]
Fax: [phone]
email: [hidden email] 
Web: www.lavolta.ch

 

[SPSS Support-2]

Hi Christian,

I've been able to replicate the behavior you're reporting. I've opened a support case on this and have filed a bug report.

David Nichols
SPSS, an IBM Company

From:	la volta statistics <[hidden email]>
To:	[hidden email]
Date:	04/27/2010 10:01 AM
Subject:	is there a way to makke empy rows in SPSS 18?
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Hi all,
 
I would like to include an empty row in a table after each category.
The code below worked for SPSS 15.
Unfortunately, SPSS 18 adds the numbers into the data cells.
Is there different way to have empty rows in tables using SPSS 18?
Thanks in advance
Christian
 
 
New File
Dataset Close All.
data list list
 /Medi(F8.0) Sex(F8.1) Age(F8.2) .
begin data
1 1 44.25
2 1 52.92
1 1 37.21
1 1 60.87
2 1 58.69
2 2 43.17
1 2 44.93
1 1 34.19
1 2 39.96
2 1 63.04
End Data.
 
Var Label Medi 'Treatment'.
Val Label Medi 1 'Verum'
               2 'Placebo'.
 
Var Label Sex "Gender".
Val Label Sex 1 "male"
              2 "female".
*Missing Values Sex (2).
 
Compute Pat = 1.
Var Label Pat "Total".
VaL Label Pat 1 " ".
 
Compute Spacer = 0.
Var Label Spacer ' '.
Val LAbel Spacer 1 ' '.
*Missing Values Spacer (0).
*RECODE Spacer (else = sysmiss).
 
CTABLES
 /FORMAT EMPTY = " " MISSING = "X "
 /VLABELS VARIABLES=Medi sex Age DISPLAY=DEFAULT
 /SMISSING VARIABLE
 /TABLE Pat [c] [Count " " F8.0]                          +
     Spacer [C] [Count " " ]                              +
        sex [C] [COUNT "N" F8.0, COLPCT.COUNT "%" PCT8.1] +
     Spacer [c] [Count " " ]                              +
       Age  [s]  [VALIDN "Valid" F8.0,
                 MEAN "Mean" F8.2,
                 MAXIMUM "Maximum" F8.2,
                 MINIMUM "Minimum" F8.2,
                 MEDIAN "Median" F8.2,
                 STDDEV "Std.dev." F8.2,
                 PTILE 25 "Percentile 25" F8.2,
                 PTILE 75 "Percentile 75" F8.2]
    BY Medi [c]
 /Titles TITLE = "My Table 1"
 /SLABELS POSITION=Row
 /CATEGORIES VARIABLES = Medi ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER
 /CATEGORIES VARIABLES = Spacer [1] EMPTY=INCLUDE
 /CATEGORIES VARIABLES=sex ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING = Exclude.
 
 
**********************************
la volta statistics
Christian Schmidhauser, Dr.phil.II
Weinbergstrasse 108
CH-8006 Zürich
Tel: [phone]
Fax: [phone]
email: mailto:schmidhauser@...
Web: www.lavolta.ch