Hi This is regarding date format

Thread View: bit.listserv.sas-l

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by vj Wed, 04 Oct 2006 16:02

#2204

Author: vj
Date: Wed, 04 Oct 2006 16:02

36 lines
2030 bytes

Hi All,
Please help me to finish this query.
I have three variables in a dataset and I have to remove null values of
acctnum and I want to abend if the invdate, invduedt is like mm-dd-yy
or mm/dd/yy.


Example:

DATA X;
INPUT  Acctnum $20.
             INVDATE MMDDYY8.
             INVDUEDT MMDDYY8.
             ;
CARDS;
A123     1/7/2004    2/29/2004
B234     3/8/2004    4/8/2004
C1122  05-09-05    4/8/2004
D2233  3/8/2004    03/09/04
.            3/8/2004    4/8/2004
.            3/9/2004    5/9/2004
.            2/8/2004    4/6/2004
.            4/8/2004    6/5/2004
C1122  02-09-06    4/8/2004
D2233  3/8/2004    03/09/08
;
RUN;

i) i want to delete the records which have Acctnum is NULL.
ii) I want to abend  if the data have  05-09-05(mm-dd-yy) format or
like 01/02/05 (mm/dd/yy)format.
 I mean can write to abend file.

Please help me to write this program..
Thank you very much in Advance..
Can you please mail me Urgent.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads