Date: Wed, 29 Mar 2006 09:38:14 -0500
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: Need Suggestion - Help
That depends on what you define as valid/invalid! E.g. the year 4002 IS
valid! Why should the year 20000 not be valid? Also 20011 = january 2001 -
So it's on you to define limits and test all the criteria.
E.g. you could say, all values with length less than 6 are invalid, maybe
even with length ne 6?
if length(compress(start))=6 and
On Wed, 29 Mar 2006 05:09:55 -0800, BD <bd301@YAHOO.COM> wrote:
>I have a dataset that contains START field. The values in this field
>is in the form of yyyymm (200501, 200502 etc). However, some of the
>values entered in this field is not VALID, such as 20051, 20200 400201
>etc. I want to flag these rows that have invalid START field. What
>is the best way to do it?