| Date: | Wed, 30 Jan 2002 19:36:00 -0500 |
|---|
| Reply-To: | Raynald Levesque <rlevesque@videotron.ca> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | Raynald Levesque <rlevesque@videotron.ca> |
|---|
| Subject: | Re: Date century values are wrong (Oopps!) |
|---|
| In-Reply-To: | <LDEEKLGKNMECOPKLIGJNMEGJCGAA.rlevesque@videotron.ca> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
Hi
Thanks to Sally Sitzer for letting me know that the syntax I posted has a
little problem.
The following corrects the "slip of the pen":
DATA LIST LIST /date1(ADATE10).
BEGIN DATA
01/01/1901
07/07/1900
END DATA.
* The folowing syntax replaces years 19xx by 20xx.
COMPUTE
date2=DATE.DMY(XDATE.MDAY(date1),XDATE.MONTH(date1),XDATE.YEAR(date1)+100).
FORMATS Date2 (ADATE10).
LIST.
Regards
Raynald Levesque rlevesque@videotron.ca
Visit My SPSS Pages: http://pages.infinit.net/rlevesqu/index.htm
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Raynald Levesque
Sent: Wednesday, January 30, 2002 7:12 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Date century values are wrong
Hi
DATA LIST LIST /date1(ADATE10).
BEGIN DATA
01/01/1901
07/07/1900
END DATA.
* The folowing syntax replaces years 19xx by 20xx.
COMPUTE date2=DATE.DMY(XDATE.MDAY(date1),XDATE.MONTH(date1),2000).
FORMATS Date2 (ADATE10).
LIST.
Raynald Levesque rlevesque@videotron.ca
Visit My SPSS Pages: http://pages.infinit.net/rlevesqu/index.htm
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
painter@email.unc.edu
Sent: Wednesday, January 30, 2002 12:27 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Date century values are wrong
Hello,
I inherited a SPSS 10.1 data file with dates as mm/dd/yyyy. The dates
started out as mm/dd/yy, and were converted to mm/dd/yyyy (I don't know
why).
Trouble is that in the current format the century is presented as 1900's,
not 2000. The Options > data century function is set to 1932 to 2032.
Any suggestion on how to restore and keep 2000 as the century instead of
1900?
Thanks,
John
--On Wednesday, January 30, 2002 10:11 AM -0700 Stella Vasquez
<StellaV@dj.state.az.us> wrote:
> I have access files I import from access on, what seems like, a daily
> basis. I'm looking for a short cut. Is there a syntax command that I
> can use to import about 6 access files using the database capture wizard?
>
>
>
> Stella Vasquez, Planner II
> AZ Department of Juvenile Corrections
> 1624 West Adams
> Phoenix, AZ 85007
> (602) 542-2272
| 
