topic date field in SAS Programming

date field

SASPhile — Tue, 20 Oct 2009 18:41:24 GMT

The date format is not consistent across the observations.
the first few rows has 09/18/2009 format and after which some rows will have
Sep-09 format.
How to make the date field consistent like mmddyy10. format?

Re: date field

Flip — Tue, 20 Oct 2009 18:45:55 GMT

Is this a SASDATE variable or text. It must be text for this to happen. Give us some information on what type of data you have.

Re: date field

SASPhile — Tue, 20 Oct 2009 18:47:31 GMT

text.
This is how i get my date field:

SHIP_DATE
09/22/2009
09/18/2009
09/22/2009
09/18/2009
Sep-09
Sep-09

Re: date field

CurtisMack — Tue, 20 Oct 2009 18:52:34 GMT

This will do it.
------------------------------------
data test;
format SHIP_DATE mmddyy10.;
input SHIP_DATE : anydtDTE10.;
cards;
09/22/2009
09/18/2009
09/22/2009
09/18/2009
Sep-09
Sep-09
;
run;
--------------------

Re: date field

Flip — Tue, 20 Oct 2009 18:53:04 GMT

input dateinfo anydtdte21.;

Re: date field

CurtisMack — Tue, 20 Oct 2009 18:56:33 GMT

If you are still working on translating those Excel spreadsheets, this is probably more what you are looking for.
------------------------------
data test;
length SHIP_DATE $10;
input SHIP_DATE;
cards;
09/22/2009
09/18/2009
09/22/2009
09/18/2009
Sep-09
Sep-09
;
run;
data test2;
set test;
format SHIP_DATE_DT mmddyy10.;
SHIP_DATE_DT = input(SHIP_DATE,anydtDTE10.);
run;
-----------------------------