replace dates with syntax

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

replace dates with syntax

Rodrigo Briceño-2
Dear SPSS experts. I'm working with a data file that has an
indentifier (ISIN3) and two dates variables (date 11 format):
DATE_ISSUE, DATE_MATURITY (example: 20-JAN-2011)

What I'm trying to do is to find 10 specific values in these two dates
variables and replace them with correct values. I'm working with
syntax and I tried the following:

if (isin3=60) DATE_ISSUE= 4/8/2009. (ERROR)
if (isin3=60) DATE_ISSUE= 04-AGO-2009. (ERROR)
if (isin3=60) DATE_ISSUE= '04-AGO-2009'. (ERROR)

Would you kindly help me to identify what I'm doing wrong?

Best regards.

--
Rodrigo Briceño
Economist
[hidden email]
MSN: [hidden email]
SKYPE: rbriceno1087

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: replace dates with syntax

Rick Oliver-3
if (isin3=60) DATE_ISSUE= date.dmy(4,8,2009).

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: 312.893.4922 | T/L: 206-4922




From:        Rodrigo Briceño <[hidden email]>
To:        [hidden email]
Date:        04/02/2012 12:16 PM
Subject:        replace dates with syntax
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Dear SPSS experts. I'm working with a data file that has an
indentifier (ISIN3) and two dates variables (date 11 format):
DATE_ISSUE, DATE_MATURITY (example: 20-JAN-2011)

What I'm trying to do is to find 10 specific values in these two dates
variables and replace them with correct values. I'm working with
syntax and I tried the following:

if (isin3=60) DATE_ISSUE= 4/8/2009. (ERROR)
if (isin3=60) DATE_ISSUE= 04-AGO-2009. (ERROR)
if (isin3=60) DATE_ISSUE= '04-AGO-2009'. (ERROR)

Would you kindly help me to identify what I'm doing wrong?

Best regards.

--
Rodrigo Briceño
Economist
[hidden email]
MSN: [hidden email]
SKYPE: rbriceno1087

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


Reply | Threaded
Open this post in threaded view
|

Re: replace dates with syntax

Rodrigo Briceño-2
thanks Rick! that's exactly what I needed.

2012/4/2 Rick Oliver <[hidden email]>:

> if (isin3=60) DATE_ISSUE= date.dmy(4,8,2009).
>
> Rick Oliver
> Senior Information Developer
> IBM Business Analytics (SPSS)
> E-mail: [hidden email]
> Phone: 312.893.4922 | T/L: 206-4922
>
>
>
> From:        Rodrigo Briceño <[hidden email]>
> To:        [hidden email]
> Date:        04/02/2012 12:16 PM
> Subject:        replace dates with syntax
> Sent by:        "SPSSX(r) Discussion" <[hidden email]>
> ________________________________
>
>
>
> Dear SPSS experts. I'm working with a data file that has an
> indentifier (ISIN3) and two dates variables (date 11 format):
> DATE_ISSUE, DATE_MATURITY (example: 20-JAN-2011)
>
> What I'm trying to do is to find 10 specific values in these two dates
> variables and replace them with correct values. I'm working with
> syntax and I tried the following:
>
> if (isin3=60) DATE_ISSUE= 4/8/2009. (ERROR)
> if (isin3=60) DATE_ISSUE= 04-AGO-2009. (ERROR)
> if (isin3=60) DATE_ISSUE= '04-AGO-2009'. (ERROR)
>
> Would you kindly help me to identify what I'm doing wrong?
>
> Best regards.
>
> --
> Rodrigo Briceño
> Economist
> [hidden email]
> MSN: [hidden email]
> SKYPE: rbriceno1087
>
> =====================
> 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
>
>



--
Rodrigo Briceño
Economist
[hidden email]
MSN: [hidden email]
SKYPE: rbriceno1087

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