wide variable display in frequencies

[Maguin, Eugene]

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

[Kirill Orlov]

I did not face your problem on ver. 22

data (f12.0)
13965275185
43130791452
61218257640
29076010546
15360044012
724832362631
34630541323
10321066137
15360044012
10321066137
14116489539
4294753342
621710103663
15360044012
724832362631
928301434337
57813747717
26186466147
724832362631
3710155063
10057458850
73264761474
223690905954
15360044012
61009237882
95396743042
223690905954
33852436683
5282036948
73834918298

frequencies output
          
        Frequency    Percent    Valid Percent    Cumulative Percent
Valid    3710155063    1    3.3    3.3    3.3
    4294753342    1    3.3    3.3    6.7
    5282036948    1    3.3    3.3    10.0
    10057458850    1    3.3    3.3    13.3
    10321066137    2    6.7    6.7    20.0
    13965275185    1    3.3    3.3    23.3
    14116489539    1    3.3    3.3    26.7
    15360044012    4    13.3    13.3    40.0
    26186466147    1    3.3    3.3    43.3
    29076010546    1    3.3    3.3    46.7
    33852436683    1    3.3    3.3    50.0
    34630541323    1    3.3    3.3    53.3
    43130791452    1    3.3    3.3    56.7
    57813747717    1    3.3    3.3    60.0
    61009237882    1    3.3    3.3    63.3
    61218257640    1    3.3    3.3    66.7
    73264761474    1    3.3    3.3    70.0
    73834918298    1    3.3    3.3    73.3
    95396743042    1    3.3    3.3    76.7
    223690905954    2    6.7    6.7    83.3
    621710103663    1    3.3    3.3    86.7
    724832362631    3    10.0    10.0    96.7
    928301434337    1    3.3    3.3    100.0
    Total    30    100.0    100.0   

23.10.2017 23:33, Maguin, Eugene пишет:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

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

[Jon Peck]

The DE width field doesn't matter for a pivot table. But I tried a 12-digit field, F12.0, and all the digits even with digit grouping turned on showed the full values.  If you activate the table and double click the row label, you should see the full precision value.

If the table properties have a maximum column width set that is too narrow, the display will triage significant figures right of the decimal and digit grouping or move to scientific notation (if not prohibited in preferences), so you might look at the table properties.  I could not get the table to drop figures left of the decimal, though.

On Mon, Oct 23, 2017 at 2:33 PM, Maguin, Eugene <[hidden email]> wrote:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

--

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

[Maguin, Eugene]

Hmmm. No problem for others. Yesterday it was that other person’s machine+spss version, which I assume was 24.

Today I used my computer, which definitely has 24.0.0.0, as yet unpatched, and I ran this and got this. Weird, isn’t it.

 

data list list/nn(f13) aa(a13).

begin data

1234567890123 1234567890123

2345678901234 2345678901234

3456789012345 3456789012345

end data.

execute.

frequencies nn aa.

 

 

nn
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890000	1	33.3	33.3	33.3
	2345678901000	1	33.3	33.3	66.7
	3456789012000	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

aa
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890123	1	33.3	33.3	33.3
	2345678901234	1	33.3	33.3	66.7
	3456789012345	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

 

 

 

From: Jon Peck [mailto:[hidden email]]
Sent: Monday, October 23, 2017 5:07 PM
To: Maguin, Eugene <[hidden email]>
Cc: SPSS List <[hidden email]>
Subject: Re: [SPSSX-L] wide variable display in frequencies

 

The DE width field doesn't matter for a pivot table. But I tried a 12-digit field, F12.0, and all the digits even with digit grouping turned on showed the full values.  If you activate the table and double click the row label, you should see the full precision value.

 

If the table properties have a maximum column width set that is too narrow, the display will triage significant figures right of the decimal and digit grouping or move to scientific notation (if not prohibited in preferences), so you might look at the table properties.  I could not get the table to drop figures left of the decimal, though.

 

On Mon, Oct 23, 2017 at 2:33 PM, Maguin, Eugene <[hidden email]> wrote:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

 

--

Jon K Peck
[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

[Maguin, Eugene]

Hi Jon, you gave me a detailed reply yesterday and I want to reply.

>> If you activate the table and double click the row label, you should see the full precision value.

 

I’m assuming you mean select table, right click, edit content (in viewer), select the leftmost column, right click, select table properties, and edit max width for row labels. So: default is 1.69 and changing to 1.89 does not widen the column and does not change the displayed value.

 

Weird isn’t it.

Gene Maguin

 

 

From: Jon Peck [mailto:[hidden email]]
Sent: Monday, October 23, 2017 5:07 PM
To: Maguin, Eugene <[hidden email]>
Cc: SPSS List <[hidden email]>
Subject: Re: [SPSSX-L] wide variable display in frequencies

 

The DE width field doesn't matter for a pivot table. But I tried a 12-digit field, F12.0, and all the digits even with digit grouping turned on showed the full values.  If you activate the table and double click the row label, you should see the full precision value.

 

If the table properties have a maximum column width set that is too narrow, the display will triage significant figures right of the decimal and digit grouping or move to scientific notation (if not prohibited in preferences), so you might look at the table properties.  I could not get the table to drop figures left of the decimal, though.

 

On Mon, Oct 23, 2017 at 2:33 PM, Maguin, Eugene <[hidden email]> wrote:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

 

--

Jon K Peck
[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

[Jon Peck]

I ran your code on my installed 24, which has the latest patches, and all the digits were displayed with or without the digit grouping option for both numeric and string versions.

On Tue, Oct 24, 2017 at 10:04 AM, Maguin, Eugene <[hidden email]> wrote:

Hmmm. No problem for others. Yesterday it was that other person’s machine+spss version, which I assume was 24.

Today I used my computer, which definitely has 24.0.0.0, as yet unpatched, and I ran this and got this. Weird, isn’t it.

 

data list list/nn(f13) aa(a13).

begin data

1234567890123 1234567890123

2345678901234 2345678901234

3456789012345 3456789012345

end data.

execute.

frequencies nn aa.

 

 

nn
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890000	1	33.3	33.3	33.3
	2345678901000	1	33.3	33.3	66.7
	3456789012000	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

aa
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890123	1	33.3	33.3	33.3
	2345678901234	1	33.3	33.3	66.7
	3456789012345	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

 

 

 

From: Jon Peck [mailto:[hidden email]]
Sent: Monday, October 23, 2017 5:07 PM
To: Maguin, Eugene <[hidden email]>
Cc: SPSS List <[hidden email]>
Subject: Re: [SPSSX-L] wide variable display in frequencies

 

The DE width field doesn't matter for a pivot table. But I tried a 12-digit field, F12.0, and all the digits even with digit grouping turned on showed the full values.  If you activate the table and double click the row label, you should see the full precision value.

 

If the table properties have a maximum column width set that is too narrow, the display will triage significant figures right of the decimal and digit grouping or move to scientific notation (if not prohibited in preferences), so you might look at the table properties.  I could not get the table to drop figures left of the decimal, though.

 

On Mon, Oct 23, 2017 at 2:33 PM, Maguin, Eugene <[hidden email]> wrote:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

 

--

Jon K Peck
[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

--

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

[Rick Oliver]

I get that same result. Also running v. 24.

On Tue, Oct 24, 2017 at 11:04 AM, Maguin, Eugene <[hidden email]> wrote:

Hmmm. No problem for others. Yesterday it was that other person’s machine+spss version, which I assume was 24.

Today I used my computer, which definitely has 24.0.0.0, as yet unpatched, and I ran this and got this. Weird, isn’t it.

 

data list list/nn(f13) aa(a13).

begin data

1234567890123 1234567890123

2345678901234 2345678901234

3456789012345 3456789012345

end data.

execute.

frequencies nn aa.

 

 

nn
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890000	1	33.3	33.3	33.3
	2345678901000	1	33.3	33.3	66.7
	3456789012000	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

aa
		Frequency	Percent	Valid Percent	Cumulative Percent
Valid	1234567890123	1	33.3	33.3	33.3
	2345678901234	1	33.3	33.3	66.7
	3456789012345	1	33.3	33.3	100.0
	Total	3	100.0	100.0

 

 

 

 

 

From: Jon Peck [mailto:[hidden email]]
Sent: Monday, October 23, 2017 5:07 PM
To: Maguin, Eugene <[hidden email]>
Cc: SPSS List <[hidden email]>
Subject: Re: [SPSSX-L] wide variable display in frequencies

 

The DE width field doesn't matter for a pivot table. But I tried a 12-digit field, F12.0, and all the digits even with digit grouping turned on showed the full values.  If you activate the table and double click the row label, you should see the full precision value.

 

If the table properties have a maximum column width set that is too narrow, the display will triage significant figures right of the decimal and digit grouping or move to scientific notation (if not prohibited in preferences), so you might look at the table properties.  I could not get the table to drop figures left of the decimal, though.

 

On Mon, Oct 23, 2017 at 2:33 PM, Maguin, Eugene <[hidden email]> wrote:

Somebody here did a frequencies run on a file for a numeric variable that shows in the data editor as having 12 digits, no decimals (f12.0, I’d say). The frequencies output showed 11 digits. Increasing the width (data editor) to 16 and redoing frequencies had no change. However, changing the type to string (a16) now showed all the digits in frequencies. I’m curious about the display discrepancy. Is there a remedy?

Thanks, Gene Maguin

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

 

--

Jon K Peck
[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

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

[Anthony Babinec]

aa and nn agree in my versions of 24.0.0.2 and 25.

 

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