|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>|
|Subject: ||Regarding date format validation|
|Content-Type: ||text/plain; charset="iso-8859-1"|
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.
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
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..
input Acctnum $5. Invdate $10. Invduedate$10.;
A123 1/2/2004 2/29/2004
B124 2/13/2004 2/4/2004
C125 7-7-05 8-4-05
D126 8-04-05 9-05-05
E 127 9-0-05 08-10-04
Please suggest me to finish this program..
Thank you very much