What am I missing about missing values for string variables?

[Art Kendall]

If you look at the variables view for oldfile, you can see that three missing
values are there.

data list list/var1 (a5).
begin data
aaaaa
     

bbbbb
n/a
N/A
end data.
dataset name oldfile.
missing values var1 ("","n/a","N/A").
frequencies variables = var1/missing=include.


However, I get an error message about  when I try this

data list list /Id (f2) Sex (a6) age (f3) educ (a20) occup (a20).
begin data
01 Male 18 HS comic
02 Female 26 PHD Chemist
03 " " 19 HS CNA
04 Male 0 MA Teacher
end data.
dataset name newfile.
list.
 missing values
 Age (-1,0)
 Sex educ occup ("","No HH member","Skipped").
execute.
compute all4 = nvalid(sex to occup) eq 4.
frequencies variables=all4.

>Warning # 4812 in column 21.  Text: No HH member
>The missing value is specified more than once.
execute.
compute all4 = nvalid(sex to occup) eq 4.
 
>Error # 4310 in column 35.  Text: )
>The numeric argument required for the function specified was not supplied.
>Execution of this command stops.
frequencies variables=all4.




-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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

String missing values cannot be longer than 8 bytes.

On Tue, Mar 31, 2020 at 9:45 AM Art Kendall <[hidden email]> wrote:

If you look at the variables view for oldfile, you can see that three missing
values are there.

data list list/var1 (a5).
begin data
aaaaa


bbbbb
n/a
N/A
end data.
dataset name oldfile.
missing values var1 ("","n/a","N/A").
frequencies variables = var1/missing=include.


However, I get an error message about  when I try this

data list list /Id (f2) Sex (a6) age (f3) educ (a20) occup (a20).
begin data
01 Male 18 HS comic
02 Female 26 PHD Chemist
03 " " 19 HS CNA
04 Male 0 MA Teacher
end data.
dataset name newfile.
list.
 missing values
 Age (-1,0)
 Sex educ occup ("","No HH member","Skipped").
execute.
compute all4 = nvalid(sex to occup) eq 4.
frequencies variables=all4.

>Warning # 4812 in column 21.  Text: No HH member
>The missing value is specified more than once.
execute.
compute all4 = nvalid(sex to occup) eq 4.

>Error # 4310 in column 35.  Text: )
>The numeric argument required for the function specified was not supplied.
>Execution of this command stops.
frequencies variables=all4.




-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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