Date: Tue, 28 Sep 1999 16:28:49 GMT0BST
Reply-To: Panos PAPANIKOLAOU <PapanikolaouP@CARDIFF.AC.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Panos PAPANIKOLAOU <PapanikolaouP@CARDIFF.AC.UK>
Subject: Re: make a new variable in excel
THANK YOU FOR YOUR EMAIL BUT THE question is
stil how to do that within Excel and that's where i essentially have
the problem. that is, i am not sure how to do with excel.
any comments are very welcome and well received.
> steer clear of excel for 19th century dates
> In SAS it is simply
> days_old = today() - DoB ;
> which can be formatted in many ways
> Datum: 28.09.99 15:54
> An: SAS-L@listserv.uga.edu
> Antwort an: PapanikolaouP@cardiff.ac.uk
> Betreff: Re: make a new variable in excel
> Dear Mr Terjeson,
> i working on excel but i a new user in this software.
> i have two queries and i would appreciate if i would receive any
> 1. i have two date-variables, X and Y, in a mm/dd/yy format.
> i want to create a new variable, say Z = X-Y.
> would you like to give me any advice how to carry on, please.
> I mean what sections should i look at the manuals and the on-line
> help and how i would apply this stuff.
> 2. some of the values that of these variables take are of the last
> century. That is, the values are like 08/25/1898.
> what is the best way to deal with these values, please.
> thank you very much indeed for taking the time to ocnsider my
> request. I look forward to hearing from you.
> Panos Papanikolaou
> Research fellow
> Cardiff, CF4 4XN
> > Hi Jim,
> > In Excel dates are only valid when --
> > Year is a number from 1900 to 9999 in Microsoft Excel for Windows
> > or 1904 to 9999 in Microsoft Excel for the
> > Macintosh.
> > As you play with Excel you will notice that any date that you create
> > which
> > is "before" Jan 1, 1900 will not even let you apply any date formats to it,
> > it is
> > basically treated as a character string.
> > HTH,
> > Mark Terjeson
> > Washington State Department of Social and Health Services
> > Division of Research and Data Analysis (RDA)
> > (360) 902-0741
> > (360) 902-0705 fax
> > mailto:email@example.com
> > > -----Original Message-----
> > > From: Jim [SMTP:NoSpam@NOSPAM.COM]
> > > Sent: Thursday, September 23, 1999 2:41 PM
> > > To: SAS-L@LISTSERV.UGA.EDU
> > > Subject: Reading Excel (xls) spreadsheet date fields
> > >
> > > NT 4.0, SP 5, SAS 7/8 for Windows. Reading an Excel spreadsheet with
> > > several columns of data. All works fine except the date fields. They are
> > > formatted as mm/dd/yyyy, some dates before Jan 1, 1900. SAS reads this
> > > variable as text. Any ideas how to get it to read it as a date? Thanks.
> > > Jim
Nursing, Health and Social Care Research Centre
Direct line: +44 (0)1222 742197
Fax: +44 (0)1222 745521