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 |
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 |
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 |
Free forum by Nabble | Edit this page |