| Date: | Fri, 31 Jan 2003 13:00:13 -0800 |
|---|
| Reply-To: | cassell.david@EPAMAIL.EPA.GOV |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV> |
|---|
| Subject: | Re: RES: earlier and later than mm/yyyy problem |
|---|
| Content-type: | text/plain; charset=us-ascii |
|---|
Erika Elizabeth Vidal <erikae@INEP.GOV.BR> wrote:
> How can I change a variable with the format 'datetime20.' to a
variable with
> the format 'mmddyy8.' ?
You have to change your date-time variable to a date variable. Then you
can
format the date variable however you like. You can do something like:
data whatever_you_like;
format date mmddyy8. ;
set old_data;
date = datepart(your_datetime_var);
run;
A SAS date variable is the number of days since 1/1/1960 . But you
can format it however you like. A SAS date-time variable is the number
of seconds since midnight of 1/1/1960 . So these are not stored the
same
way, and you have to use something like the datepart() function to make
the translation.
HTH,
David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician
| 
