| Date: | Thu, 5 Oct 2006 13:08:35 -0700 |
|---|
| Reply-To: | vj <vijay_sas@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | vj <vijay_sas@HOTMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Regarding date format validation |
|---|
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Hi All,
Please help me anybody how do I validate for a date format.
First of all I gave already this problem yesterday. Nat Wood told
me.Infact I didn't mention correct query.
Now I am coming from the scratch.
I have a data set which has three variables. 1. Acctnum 2. Invdate 3.
Invduedate.
I want to remove Null values in Acctnum. And I want to write to file
Abend if Invdate,Invduedate don't have mm-dd-yy format. I mean Other
than mm-dd-yy format should be abend.
I am working in Mainframe(SAS). I have an existing data set created
already.
I want to adjust what ever we write the code in existing data step.
My existing data step can create number of output data sets , can
create several outputs using file and put statements.
.I have data like this..
data x;
input Acctnum $5. Invdate $10. Invduedate$10.;
cards;
A123 1/2/2004 2/29/2004
B124 2/13/2004 2/4/2004
4/4/2005 5/5/2005
5/5/2005 6/6/2005
C125 7-7-05 8-4-05
D126 8-04-05 9-05-05
E 127 9-0-05 08-10-04
;
RUN;
Please suggest me to finish this program..
Thank you very much
VJ...
| 
