Date: Thu, 10 Oct 2002 09:27:46 -0400
Reply-To: Mahbub Khandoker <Mahbub_Khandoker@camh.net>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Mahbub Khandoker <Mahbub_Khandoker@camh.net>
Subject: Re: Practical help with transferring data with dates from Excel t
o SPSS
Content-Type: text/plain; charset="iso-8859-1"
Hi Peter,
You can transfer excel files to SPSS as usual and then the following syntax
can convert string to date format.
COMPUTE new_dt=NUMBER(old_dt,SDATE10).
FORMATS new_dt (ADATE11).
Execute.
Cheers.
Mahbub Khandoker
Analyst
Decision Support
Centre for Addiction and Mental Health
1001 Queen Street West
Toronto, Ontario, Canada
M6J 1H4
Phone: 416 535 8501 X 6534
-----Original Message-----
From: Peter Kaminski [mailto:Peter.Kaminski@glacomen.scot.nhs.uk]
Sent: October 10, 2002 5:19 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Practical help with transferring data with dates from Excel to
SPSS
I have a number of spreadsheets that I am trying to transfer from Excel
to SPSS for analysis. As I have previously posted the dates in one
column of my excel file come out in SPSS as just a string of numbers.
How can I transfer this data from Excel in the format dd/mm/yy into a
column in SPSS with the format dd/mm/yy that I can then do frequency
analysis on?
Thanks in advance to any wonderkid who can help
Peter Kaminski
Research Nurse
Greater Glasgow Primary Care NHS Trust
Florence Street Resource Centre
26 Florence Street
Glasgow
G5 0YX
Telephone: 0141-429-2878
Mobile: 07884475269
e-mail: Peter.Kaminski@glacomen.scot.nhs.uk
Privileged and confidential information and/or copyright material may be
contained in this e-mail. The information and material is intended for
the use of the intended addressee only. If you are not the intended
addressee you may not copy or deliver it to anyone else or use it in any
unauthorised manner. To do so is prohibited and may be unlawful. If you
receive this e-mail by mistake, please advise the sender immediately by
return e-mail and destroy all copies. Thank you
