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
Content-Type: text/plain; charset="iso-8859-1"
You can transfer excel files to SPSS as usual and then the following syntax
can convert string to date format.
FORMATS new_dt (ADATE11).
Centre for Addiction and Mental Health
1001 Queen Street West
Toronto, Ontario, Canada
Phone: 416 535 8501 X 6534
From: Peter Kaminski [mailto:Peter.Kaminski@glacomen.scot.nhs.uk]
Sent: October 10, 2002 5:19 AM
Subject: Practical help with transferring data with dates from Excel to
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
Thanks in advance to any wonderkid who can help
Greater Glasgow Primary Care NHS Trust
Florence Street Resource Centre
26 Florence Street
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