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 (July 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 7 Jul 2006 09:25:35 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: date validation

If I try to interpret: maybe the char - dates are of the format ddmmyy10.

Means, the dates are all like

On Fri, 7 Jul 2006 06:50:44 -0400, Jim Groeneveld <jim2stat@YAHOO.CO.UK> wrote:

>Hi Jeli, > >I don't quite understand what you are saying. You have two dates as >character fields and the rest as numeric fields. So far so good if with >numeric you mean the number of days since 01jan1960 and not a number which >contains a recognizable day, month and year part. > >Next you say your QC has to make sure the dates are all of the format >DDMMYY10. That is what I don't understand: dates are stored as either >character values (with a certain format, like DDMMYY10.) or numeric values >without a format, to be presented with _any_ format, like DDMMYY10. The >last storage form is best: N of days since 01jan1060, stored in 8 bytes >(the default for numeric values). You can make direct calculations with >these dates. > >So maybe you could elaborate a little bit more on what your QC actually >demands for date fields. > >Regards - Jim. >-- >Jim Groeneveld, Netherlands >Statistician, SAS consultant >home.hccnet.nl/jim.groeneveld > > >On Fri, 7 Jul 2006 03:31:07 -0700, jeli0703@HOTMAIL.CO.UK wrote: > >>Was wondering if anyone can help my friday mind block >> >>I have a dataset with a number of variables in it, some of which are >>dates. >> >>However 2 of the date variables are in character format whilst all the >>others are numeric, thus i can assume that if it was incorrect it would >>be ., >> >>i need to pass it through a quality check to make sure that the dates >>are in the correct format ddmmyy10. and if they fall outside todays >>date then suspend that observation otherwise good data. >> >>any help??


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