working with date vars

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

working with date vars

Raffe, Sydelle, SSA
 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
Reply | Threaded
Open this post in threaded view
|

Re: working with date vars

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

Re: working with date vars

Raffe, Sydelle, SSA
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







 
Reply | Threaded
Open this post in threaded view
|

Re: working with date vars

Raffe, Sydelle, SSA
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