Date: Sat, 20 Apr 2002 20:37:00 +0100
Reply-To: Joćo Duarte <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Joćo Duarte <firstname.lastname@example.org>
Subject: Re: importing excel
Content-Type: text/plain; charset=ISO-8859-1
I suppose this syntax will help you.
******* begin syntax ***************.
******* end syntax ***************.
ee=date variable imported from excel
ss=new date variable created by spsss.
the format is optional. you can choose another manually or by
Citando "Jaffee, Marianne" <email@example.com>:
} I've been reading your posts and I am truly humbled
} by the level of work you
} all do in SPSS. I on the other hand, remain in the
} bottom half of the stat
} pool with my questions: today this is my problem:
} I am trying to import raw data from an excel
} spreadsheet and everything is
} fine except for the variable that is a date....it
} converts it to a number
} and does not hold the "date" format given in Excel.
} When I try to read the
} data as a text file, again, most comes in fine except
} for several cases
} where the data columns are off by one or two.
} When you all bring data in from excel, is there a way
} to define one of your
} data elements as a date? I know there are other
} options but it seems SPSS
} should be able to handle this.
} Thanks in advance!
} Marianne Jaffee
Webmail da rede SAPO - http://webmail.sapo.pt/