Table not copying

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Table not copying

John F Hall

The UK Poverty and Social Exclusion survey 2012 has a list of 13 items, payment for which may be in arrears.

 

count debts = indebt1 to indebt13 (1).

formats debts (f2.0).

var lev debts (scale).

var lab debts 'Number of items in arrears'.

freq debts.

 

Number of items in arrears

 

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

0

9331

77.1

77.1

77.1

1

1022

8.4

8.4

85.6

2

661

5.5

5.5

91.0

3

498

4.1

4.1

95.2

4

241

2.0

2.0

97.2

5

137

1.1

1.1

98.3

6

92

0.8

0.8

99.0

7

71

0.6

0.6

99.6

8

19

0.2

0.2

99.8

9

15

0.1

0.1

99.9

10

4

0.0

0.0

100.0

11

5

0.0

0.0

100.0

13

1

0.0

0.0

100.0

Total

12097

100.0

100.0

 

 

I edited this in Pivot Tables to:

 

Number of items in arrears

 

Valid Percent

Valid

0

77.1

1

8.4

2

5.5

3

4.1

4

2.0

5

1.1

6

0.8

7

0.6

8

0.2

9

0.1

10

0.0

11

0.0

13

0.0

N = 100%

12097

 

After further editing of the (hidden) border between the label and the items to narrow the column and hide "Valid" all I get when copying to Word or Outlookis:

 

debts Number of items in debt for

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When copied to Excel it is OK:

 

Number of items in arrears

 

Valid Percent

Valid

0

77.1

1

8.4

2

5.5

3

4.1

4

2.0

5

1.1

6

0.8

7

0.6

8

0.2

9

0.1

10

0.0

11

0.0

13

0.0

N = 100%

12097

 

Why won't the edited table copy to Word or Outlook?

 

John F Hall  MA (Cantab) Dip Ed (Dunelm)

[Retired academic survey researcher]

 

Email:          [hidden email]

Website:     Journeys in Survey Research

Course:       Survey Analysis Workshop (SPSS)

Research:   Subjective Social Indicators (Quality of Life)

 

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