Date: Mon, 15 Jan 2007 02:28:49 -0800
Reply-To: sunny <praveencbharadwaj@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: sunny <praveencbharadwaj@GMAIL.COM>
Organization: http://groups.google.com
Subject: Re: DATE INFORMATS AND FORMATS
In-Reply-To: <200701121654.l0CFWkYo015172@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"
Tabachenek,
thank u very much for clearing my doubt in the date informats and
formats.
by using this i can really work on any datetime formats and informats.
This has helped me in my project and made me to use in comparison of
two date columns.
thank u very much.
Sunny.
Arthur Tabachneck wrote:
> Praveen,
>
> SAS dates and times are not really my forte but, since no one else has
> answered your post, you could use something like the following:
>
> data have;
> input @1 rawdata $16.;
> format date date9.;
> format time hhmm.;
> date=input(substr(rawdata,1,6),ddmmyy6.);
> time=input(substr(rawdata,7,8),TIME8.);
> cards;
> 120107 12:30 am
> 120107 1:30 pm
> 110107 12:30 am
> 110107 4:30 am
> ;
> run;
>
> Art
> ------------
> On Thu, 11 Jan 2007 20:25:19 -0800, sunny <praveencbharadwaj@GMAIL.COM>
> wrote:
>
> >Hi,
> >
> >can u please explain me the date informats and formats.
> >if i have the ddmmyy 12:30 am and mmddyy 12:30 am
> >As such can u please explain me how to read the date from the .csv SAS
> >dataset
> >for creating the SAS dataset.
> >
> >Praveen Cheruvu.
|