Interesting data label issue

[millesr]

I have an interesting data label issue that some may be familiar with
in SPSS 17. Below is the input and output supplying to and from
SPSS. I've skipped a good deal of both the input and output to
isolate a case of error.

You can see below the output refers to single values being used more
than once. I've checked thouroughly, and no values are being
duplicated. It seems that SPSS is ignoring the letter components of
the names. While I've specified the data column to be a string, it
appears that SPSS will not take letters to assign a value label. Does
anyone know if this is true?

Any thoughts will be greatly appreciated.

Steve

*** INPUT FILE ****
FILE HANDLE IN/NAME="C:\Documents and Settings\aec_user\My Documents
\projects\MIGRATION\mill1707fpj5lcny1.asc" lrecl=264.
DATA LIST FILE=IN FREE /
PWGTP (F10.0)
AGEP (F10.0)
ANC (F10.0)
WAGP (F10.0)
MAR (F10.0)
ST (F10.0)
WGTP (F10.0)
FINCP (F10.0)
HINCP (F10.0)
MV (F10.0)
MIGPUMA (F10.0)
YOEP (F10.0)
CIT (F10.0)
MSP (F10.0)
SCHL (F10.0)
FPARC (F10.0)
INDP (A10)
MIGSP (A10)
NATIVITY (F10.0)
NOP (F10.0)
HISP (F10.0)
PERNP (F10.0)
PINCP (F10.0)
NAICSP (A8) .

.
.
.

VALUE LABELS NAICSP
0 'Not in universe - missing'
111 'AGR-CROP PRODUCTION'
112 'AGR-ANIMAL PRODUCTION'
1133 'AGR-LOGGING'
113M 'AGR-FORESTRY EXCEPT LOGGING'
114 'AGR-FISHING, HUNTING, AND TRAPPING'
115 'AGR-SUPPORT ACTIVITIES FOR AGRICULTURE AND FORESTRY'
211 'EXT-OIL AND GAS EXTRACTION'
213 'EXT-SUPPORT ACTIVITIES FOR MINING'
2121 'EXT-COAL MINING'
2122 'EXT-METAL ORE MINING'
.
.
.
811192 'SRV-CAR WASHES'
8111Z 'SRV-AUTOMOTIVE REPAIR AND MAINTENANCE'
8112 'SRV-ELECTRONIC AND PRECISION EQUIPMENT REPAIR AND MAINTENANCE'
8113 'SRV-COMMERCIAL AND INDUSTRIAL MACHINERY AND EQUIPMENT REPAIR
AND MAINTENANCE'
8114 'SRV-PERSONAL AND HOUSEHOLD GOODS REPAIR AND MAINTENANCE'
81143 '81143'
8114Z '8114Z'
812111 'SRV-BARBER SHOPS'
812112 'SRV-BEAUTY SALONS'
8121M 'SRV-NAIL SALONS AND OTHER PERSONAL CARE SERVICES'
8122 'SRV-FUNERAL HOMES, CEMETERIES AND CREMATORIES'
8123 'SRV-DRYCLEANING AND LAUNDRY SERVICES'
8129 'SRV-OTHER PERSONAL SERVICES'
8131 'SRV-RELIGIOUS ORGANIZATIONS'
81393 'SRV-LABOR UNIONS'
8139Z 'SRV-BUSINESS, PROFESSIONAL, POLITICAL AND SIMILAR
ORGANIZATIONS'
813M 'SRV-CIVIC, SOCIAL, ADVOCACY ORGANIZATIONS, AND GRANTMAKING AND
GIVING SERVICES'
814 'SRV-PRIVATE HOUSEHOLDS'
92113 'ADM-PUBLIC FINANCE ACTIVITIES'
92119 'ADM-OTHER GENERAL GOVERNMENT AND SUPPORT'
9211MP 'ADM-EXECUTIVE OFFICES AND LEGISLATIVE BODIES'
923 'ADM-ADMINISTRATION OF HUMAN RESOURCE PROGRAMS'
928110P1 'MIL-U.S. ARMY'
928110P2 'MIL-U.S. AIR FORCE'
928110P3 'MIL-U.S. NAVY'
928110P4 'MIL-U.S. MARINES'
928110P5 'MIL-U.S. COAST GUARD'
928110P6 'MIL-U.S. ARMED FORCES, BRANCH NOT SPECIFIED'
928110P7 'MIL-MILITARY RESERVES OR NATIONAL GUARD'
928P 'ADM-NATIONAL SECURITY AND INTERNATIONAL AFFAIRS'
92M1 'ADM-ADMINISTRATION OF ENVIRONMENTAL QUALITY AND HOUSING
PROGRAMS'
92M2 'ADM-ADMINISTRATION OF ECONOMIC PROGRAMS AND SPACE RESEARCH'
92MP 'ADM-JUSTICE, PUBLIC ORDER, AND SAFETY ACTIVITIES'
9920 'UNEMPLOYED, WITH NO WORK EXPERIENCE IN THE LAST 5 YEARS**'
.
.
.
*** END OF INPUT FILE ***

*** OUTPUT FILE ***
.
.
.
VALUE LABELS NAICSP
0 'Not in universe - missing'
111 'AGR-CROP PRODUCTION'
112 'AGR-ANIMAL PRODUCTION'
1133 'AGR-LOGGING'
113M 'AGR-FORESTRY EXCEPT LOGGING'
114 'AGR-FISHING, HUNTING, AND TRAPPING'
115 'AGR-SUPPORT ACTIVITIES FOR AGRICULTURE AND FORESTRY'
211 'EXT-OIL AND GAS EXTRACTION'
213 'EXT-SUPPORT ACTIVITIES FOR MINING'
2121 'EXT-COAL MINING'
2122 'EXT-METAL ORE MINING'
.
.
.
.
811192 'SRV-CAR WASHES'
8111Z 'SRV-AUTOMOTIVE REPAIR AND MAINTENANCE'
8112 'SRV-ELECTRONIC AND PRECISION EQUIPMENT REPAIR AND MAINTENANCE'
8113 'SRV-COMMERCIAL AND INDUSTRIAL MACHINERY AND EQUIPMENT REPAIR
AND MAINTENANCE'
8114 'SRV-PERSONAL AND HOUSEHOLD GOODS REPAIR AND MAINTENANCE'
81143 '81143'
8114Z '8114Z'

>Warning # 4488 in column 2. Text: 8114
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
812111 'SRV-BARBER SHOPS'
812112 'SRV-BEAUTY SALONS'
8121M 'SRV-NAIL SALONS AND OTHER PERSONAL CARE SERVICES'
8122 'SRV-FUNERAL HOMES, CEMETERIES AND CREMATORIES'
8123 'SRV-DRYCLEANING AND LAUNDRY SERVICES'
8129 'SRV-OTHER PERSONAL SERVICES'
8131 'SRV-RELIGIOUS ORGANIZATIONS'
81393 'SRV-LABOR UNIONS'
8139Z 'SRV-BUSINESS, PROFESSIONAL, POLITICAL AND SIMILAR
ORGANIZATIONS'
813M 'SRV-CIVIC, SOCIAL, ADVOCACY ORGANIZATIONS, AND GRANTMAKING AND
GIVING SERVICES'
814 'SRV-PRIVATE HOUSEHOLDS'
92113 'ADM-PUBLIC FINANCE ACTIVITIES'
92119 'ADM-OTHER GENERAL GOVERNMENT AND SUPPORT'
9211MP 'ADM-EXECUTIVE OFFICES AND LEGISLATIVE BODIES'
923 'ADM-ADMINISTRATION OF HUMAN RESOURCE PROGRAMS'
928110P1 'MIL-U.S. ARMY'
928110P2 'MIL-U.S. AIR FORCE'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928110P3 'MIL-U.S. NAVY'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928110P4 'MIL-U.S. MARINES'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928110P5 'MIL-U.S. COAST GUARD'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928110P6 'MIL-U.S. ARMED FORCES, BRANCH NOT SPECIFIED'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928110P7 'MIL-MILITARY RESERVES OR NATIONAL GUARD'

>Warning # 4488 in column 2. Text: 928110
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
928P 'ADM-NATIONAL SECURITY AND INTERNATIONAL AFFAIRS'
92M1 'ADM-ADMINISTRATION OF ENVIRONMENTAL QUALITY AND HOUSING
PROGRAMS'
92M2 'ADM-ADMINISTRATION OF ECONOMIC PROGRAMS AND SPACE RESEARCH'

>Warning # 4488 in column 2. Text: 92
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
92MP 'ADM-JUSTICE, PUBLIC ORDER, AND SAFETY ACTIVITIES'

>Warning # 4488 in column 2. Text: 92
>The (ADD) VALUE LABELS command specifies a given value more than once for a
>given set of variables. The label appearing with the first occurrence of the
>value will be retained.
9920 'UNEMPLOYED, WITH NO WORK EXPERIENCE IN THE LAST 5 YEARS**'
.
.
.
.
*** END OF OUTPUT FILE ***

[Ben Pfaff]

millesr <econ....@gmail.com> writes:

> VALUE LABELS NAICSP
> 0 'Not in universe - missing'
> 111 'AGR-CROP PRODUCTION'
> 112 'AGR-ANIMAL PRODUCTION'
> 1133 'AGR-LOGGING'
> 113M 'AGR-FORESTRY EXCEPT LOGGING'

I think that you should put your values in quotes, e.g.:

VALUE LABELS NAICSP
'0' 'Not in universe - missing'
'111' 'AGR-CROP PRODUCTION'
'112' 'AGR-ANIMAL PRODUCTION'
'1133' 'AGR-LOGGING'
'113M' 'AGR-FORESTRY EXCEPT LOGGING'

...
--
Ben Pfaff
http://benpfaff.org

[millesr]

On Jan 4, 2:24 am, Ben Pfaff <b...@cs.stanford.edu> wrote:

Ben,

That did it. Thank you much!
Steve