query in spss

[Manoj Soni]

Dear listers.

 

How can we calculate age in days  from today’s date , if original date of birth is recorded in three different variables, i.e. day, month and year.

Thanks in advance.

Regards

Manoj

[Maguin, Eugene]

Manoj,

 

Use the YRMODA function. Look this function up in help or CSR but like this

 

ageindays=yrmoda(todayyear,todaymonth,todayday)-yrmoda(dobyear,dobmonth,dobday)-

 

Gene Maguin

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Manoj Soni
Sent: Wednesday, May 18, 2011 8:29 AM
To: [hidden email]
Subject: query in spss

Dear listers.

 

How can we calculate age in days  from today’s date , if original date of birth is recorded in three different variables, i.e. day, month and year.

Thanks in advance.

Regards

Manoj

[David Marso]

Something like (Untested -no SPSS installed on my Mac OSX partition-)
COMPUTE AGETODAY=CTIME.DAYS($DATE-DATE.MDY(Month,Day,Year)).

Manoj Soni wrote

Dear listers.

How can we calculate age in days  from today's date , if original date of
birth is recorded in three different variables, i.e. day, month and year.

Thanks in advance.

Regards

Manoj

[David Marso]

I generally avoid YRMODA like the plague.
1.  It does not return a value in the same metric as other date conversion DATE.xxx functions (seconds).
2.  It does not play nice with other date functions (it must be multiplied by 86400 first).
3.  It is a throwback to SPSS-PC+ and the *OLD* pre SPSS-X mainframe versions.

Gene Maguin wrote

Manoj,

Use the YRMODA function. Look this function up in help or CSR but like this

ageindays=yrmoda(todayyear,todaymonth,todayday)-yrmoda(dobyear,dobmonth,dobd
ay)-

Gene Maguin

  _____

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Manoj Soni
Sent: Wednesday, May 18, 2011 8:29 AM
To: [hidden email]
Subject: query in spss



Dear listers.



How can we calculate age in days  from today's date , if original date of
birth is recorded in three different variables, i.e. day, month and year.

Thanks in advance.

Regards

Manoj

[Jon K Peck]

To add to Gene's solution, you may find the Date and Time wizard on the Transform menu helpful in figuring out how to manipulate date and time data.

Jon Peck
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Gene Maguin <[hidden email]>
To:        [hidden email]
Date:        05/18/2011 10:04 AM
Subject:        Re: [SPSSX-L] query in spss
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Manoj,
 
Use the YRMODA function. Look this function up in help or CSR but like this
 
ageindays=yrmoda(todayyear,todaymonth,todayday)-yrmoda(dobyear,dobmonth,dobday)-
 
Gene Maguin

---

From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Manoj Soni
Sent: Wednesday, May 18, 2011 8:29 AM
To: [hidden email]
Subject: query in spss

Dear listers.
 
How can we calculate age in days  from today’s date , if original date of birth is recorded in three different variables, i.e. day, month and year.
Thanks in advance.
Regards
Manoj