LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 10 Oct 2002 09:27:46 -0400
Reply-To:     Mahbub Khandoker <>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Mahbub Khandoker <>
Subject:      Re: Practical help with transferring data with dates from Excel t
              o SPSS
Comments: To: Peter Kaminski <>
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 [] 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:

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

Back to: Top of message | Previous page | Main SPSSX-L page