I know I need to use date/time functions but am unclear how.
If dates were numbers, I'd like to say if not(missing(appdt03)) appdate = appdt03. exe. Thanks as always. Sydelle Raffe, Alameda County Social Services Agency Information Services Division e:mail: [hidden email] phone: 510-271-9174 fax: 510-271-9107 If you have a request for information, please submit an ODM request form at: https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm |
Internally, dates are numbers; so your syntax should work just fine. If appdate isn't already a defined date format variable, just add a Formats command, as in:
Formats appdate(date11). -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Raffe, Sydelle, SSA Sent: Thursday, March 01, 2007 3:49 PM To: [hidden email] Subject: working with date vars I know I need to use date/time functions but am unclear how. If dates were numbers, I'd like to say if not(missing(appdt03)) appdate = appdt03. exe. Thanks as always. Sydelle Raffe, Alameda County Social Services Agency Information Services Division e:mail: [hidden email] phone: 510-271-9174 fax: 510-271-9107 If you have a request for information, please submit an ODM request form at: https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm |
In reply to this post by Raffe, Sydelle, SSA
Thanks for the quick rsesponse which I'll try. Re your last question, I have a series of 10 months to do.
-----Original Message----- From: Victor Kogler [mailto:[hidden email]] Sent: Thursday, March 01, 2007 2:08 PM To: Raffe, Sydelle, SSA Subject: Re: working with date vars I think you'd want to use something like: "IF (appdt03 ne SYSMIS(appdt03)) appdate = appdt03 ." However, if the value is missing in appdt03, wouldn't a simple Compute appdate=appdt03. give the same result? Anyway, hope this helps. Raffe, Sydelle, SSA wrote: I know I need to use date/time functions but am unclear how. If dates were numbers, I'd like to say if not(missing(appdt03)) appdate = appdt03. exe. Thanks as always. Sydelle Raffe, Alameda County Social Services Agency Information Services Division e:mail: [hidden email] phone: 510-271-9174 fax: 510-271-9107 If you have a request for information, please submit an ODM request form at: https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm |
In reply to this post by Oliver, Richard
I may have used the wrong format. Thank you.
-----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of Oliver, Richard Sent: Thursday, March 01, 2007 2:23 PM To: [hidden email] Subject: Re: working with date vars Internally, dates are numbers; so your syntax should work just fine. If appdate isn't already a defined date format variable, just add a Formats command, as in: Formats appdate(date11). -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Raffe, Sydelle, SSA Sent: Thursday, March 01, 2007 3:49 PM To: [hidden email] Subject: working with date vars I know I need to use date/time functions but am unclear how. If dates were numbers, I'd like to say if not(missing(appdt03)) appdate = appdt03. exe. Thanks as always. Sydelle Raffe, Alameda County Social Services Agency Information Services Division e:mail: [hidden email] phone: 510-271-9174 fax: 510-271-9107 If you have a request for information, please submit an ODM request form at: https://alamedasocialservices.org/staff/support_services/statistics_and_reports/odm/index.cfm |
Free forum by Nabble | Edit this page |