missing on dates

[Rodrigo Briceño]

Dear SPSS listers. I have a variable with dates (25-FEB-1900) that contains
some missing values. Those values appear as dots, but are taken as values
when processing some functions. I want to transform these dots to missing
values, but  I can’t do that from the variable view.  I tried with syntax
as:

missing values dis_date (.). where dis_date is the name of my variable.

 

 

__________________________________________________________________

Rodrigo Briceño
Project Manager
Sanigest Internacional

[phone] ext. 113   Oficina Costa Rica
[phone]                   Fax
[phone]                   Celular
 <mailto:[hidden email]> [hidden email]
 <http://www.sanigest.com/> www.sanigest.com

MSN:  <mailto:[hidden email]> [hidden email]
SKYPE: rbriceno1087

_____________________

This communication contains legal information which is privileged and
confidential. It is for the exclusive use of the address and distribution,
dissemination, copying or use by others is strictly prohibited. If you have
received this communication by error, please delete the original message and
e-mail us.


Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación, copia
u otro uso por terceras personas es estrictamente prohibida. Si usted ha
recibido esta comunicación por error, le rogamos borrar el mensaje original
y comunicárnoslo a esta misma dirección.

 

[Peck, Jon]

Is your date variable a string or a true SPSS date variable?  The dot suggests a standard SPSS sysmis value, but that would never be taken as a value in SPSS.

If you have specific dates for a date variable that should be declared missing, you can do it with
missing values x ('date').
where the date is written according to the variable's format, e.g. '02/10/1999'.

You cannot assign these values in the Data Editor, but you can do it easily with Data/Define Variable Properties, which displays a list of all the variable values and lets you just check the ones that indicate missing.

But, again, sysmis is sysmis and will never be treated as a regular value.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rodrigo Briceno
Sent: Monday, August 13, 2007 11:07 AM
To: [hidden email]
Subject: [SPSSX-L] missing on dates

Dear SPSS listers. I have a variable with dates (25-FEB-1900) that contains
some missing values. Those values appear as dots, but are taken as values
when processing some functions. I want to transform these dots to missing
values, but  I can’t do that from the variable view.  I tried with syntax
as:

missing values dis_date (.). where dis_date is the name of my variable.





__________________________________________________________________

Rodrigo Briceño
Project Manager
Sanigest Internacional

[phone] ext. 113   Oficina Costa Rica
[phone]                   Fax
[phone]                   Celular
 <mailto:[hidden email]> [hidden email]
 <http://www.sanigest.com/> www.sanigest.com

MSN:  <mailto:[hidden email]> [hidden email]
SKYPE: rbriceno1087

_____________________

This communication contains legal information which is privileged and
confidential. It is for the exclusive use of the address and distribution,
dissemination, copying or use by others is strictly prohibited. If you have
received this communication by error, please delete the original message and
e-mail us.


Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación, copia
u otro uso por terceras personas es estrictamente prohibida. Si usted ha
recibido esta comunicación por error, le rogamos borrar el mensaje original
y comunicárnoslo a esta misma dirección.

[Oliver, Richard]

Consider the following:

data list free /datevar (f12).
begin data
123
456
86400
end data.
formats datevar (date11).
frequencies datevar.
if datevar < 86400 datevar=$sysmis.
frequencies datevar.

The first two are valid values but cannot be displayed as valid dates and are therefore displayed with the system-missing symbol -- but they are not treated as system-missing in the first frequency table. Instead, you have two entries in the "Valid" sectiion, each represented with the system-missing symbol. In the second table, all internal date values below the minimum date value of 86400 are set to system-missing.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Peck, Jon
Sent: Monday, August 13, 2007 12:19 PM
To: [hidden email]
Subject: Re: missing on dates

Is your date variable a string or a true SPSS date variable?  The dot suggests a standard SPSS sysmis value, but that would never be taken as a value in SPSS.

If you have specific dates for a date variable that should be declared missing, you can do it with
missing values x ('date').
where the date is written according to the variable's format, e.g. '02/10/1999'.

You cannot assign these values in the Data Editor, but you can do it easily with Data/Define Variable Properties, which displays a list of all the variable values and lets you just check the ones that indicate missing.

But, again, sysmis is sysmis and will never be treated as a regular value.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rodrigo Briceno
Sent: Monday, August 13, 2007 11:07 AM
To: [hidden email]
Subject: [SPSSX-L] missing on dates

Dear SPSS listers. I have a variable with dates (25-FEB-1900) that contains
some missing values. Those values appear as dots, but are taken as values
when processing some functions. I want to transform these dots to missing
values, but  I can't do that from the variable view.  I tried with syntax
as:

missing values dis_date (.). where dis_date is the name of my variable.





__________________________________________________________________

Rodrigo Briceño
Project Manager
Sanigest Internacional

[phone] ext. 113   Oficina Costa Rica
[phone]                   Fax
[phone]                   Celular
 <mailto:[hidden email]> [hidden email]
 <http://www.sanigest.com/> www.sanigest.com

MSN:  <mailto:[hidden email]> [hidden email]
SKYPE: rbriceno1087

_____________________

This communication contains legal information which is privileged and
confidential. It is for the exclusive use of the address and distribution,
dissemination, copying or use by others is strictly prohibited. If you have
received this communication by error, please delete the original message and
e-mail us.


Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación, copia
u otro uso por terceras personas es estrictamente prohibida. Si usted ha
recibido esta comunicación por error, le rogamos borrar el mensaje original
y comunicárnoslo a esta misma dirección.