DateDif per Event Per Person

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

melissab_data
Posts: 1
Joined: Thu Apr 07, 2016 10:15 am

DateDif per Event Per Person

Postby melissab_data » Thu Apr 07, 2016 10:34 am

Hi there

I am quite new to SPSS, yet have experience in SQL and Excel.

I need to work out the difference in days between each booking date, per account ID.

Data is sorted ASCENDING - Is there an equation/Node i can use in SPSS MODELLER to create a variable for further analysis?


accountId booking_date
12229 26-Jan-15
12229 19-Feb-15
12229 19-Aug-15
12229 19-Aug-15
12229 24-Aug-15
12229 24-Aug-15
12229 13-Oct-15
12229 02-Nov-15
12229 08-Mar-16
18269923 10-Jul-15
18297399 11-Jul-14
18303706 10-Dec-15
18303706 11-Mar-16
18304312 12-Nov-15
18741471 05-Sep-14
18741471 29-Sep-14
18741471 08-Oct-14
18741471 23-Nov-14
18741471 29-Nov-14
18741471 07-Dec-14
statman
Administrator
Posts: 2737
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: DateDif per Event Per Person

Postby statman » Thu Apr 07, 2016 12:42 pm

Few, including myself, on this forum use Modeler so be patient
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statman
Statistical Services

Who is online

Users browsing this forum: No registered users and 1 guest

cron