Permissible date range

[Benjamin Spivak (Med)]

Hi everybody,

I am putting together a database and I am using date variables. I would like to set my missing values to something memorable e.g. "10.10.1000". However, it seems that SPSS limits the permissible date inputs to years above 1500. Is there some way around this?

Thanks.

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

[Mark Miller]

SPSS Date "0" is  number of seconds from midnight, October 14, 1582 (the beginning of the Gregorian calendar).

On Tue, Jun 21, 2016 at 9:31 PM, Benjamin Spivak <[hidden email]> wrote:

Hi everybody,

I am putting together a database and I am using date variables. I would like to set my missing values to something memorable e.g. "10.10.1000". However, it seems that SPSS limits the permissible date inputs to years above 1500. Is there some way around this?

Thanks.

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

[Benjamin Spivak (Med)]

Thanks Mark,

Can it be changed?

Cheers,

Ben

On 22 June 2016 at 15:16, Mark Miller <[hidden email]> wrote:

SPSS Date "0" is  number of seconds from midnight, October 14, 1582 (the beginning of the Gregorian calendar).

On Tue, Jun 21, 2016 at 9:31 PM, Benjamin Spivak <[hidden email]> wrote:

Hi everybody,

I am putting together a database and I am using date variables. I would like to set my missing values to something memorable e.g. "10.10.1000". However, it seems that SPSS limits the permissible date inputs to years above 1500. Is there some way around this?

Thanks.

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

[Bruce Weaver]

No, I don't think so.  But given that 9 (or 99, 999, etc) is frequently used as a missing value, why not make 9-SEP-9999 your missing value?  The numeric value of that date is 265611830400.  So just do this:

MISSING VALUES DateVar(265611830400).

E.g.,

DATA LIST LIST / DateVar(DATE11).
BEGIN DATA
22-Jun-2016
9-Sep-9999
END DATA.

MISSING VALUES DateVar(265611830400).
FREQUENCIES DateVar.

Benjamin Spivak (Med) wrote

Thanks Mark,

Can it be changed?

Cheers,

Ben

On 22 June 2016 at 15:16, Mark Miller <[hidden email]> wrote:

> SPSS Date "0" is  number of seconds from midnight, October 14, 1582 (the
> beginning of the Gregorian calendar).
>
> On Tue, Jun 21, 2016 at 9:31 PM, Benjamin Spivak <
> [hidden email]> wrote:
>
>> Hi everybody,
>>
>> I am putting together a database and I am using date variables. I would
>> like to set my missing values to something memorable e.g. "10.10.1000".
>> However, it seems that SPSS limits the permissible date inputs to years
>> above 1500. Is there some way around this?
>>
>> Thanks.
>>
>> ===================== 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