| Date: | Tue, 12 Feb 2008 08:21:26 -0800 |
| Reply-To: | "raghur6@gmail.com" <raghur6@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | "raghur6@gmail.com" <raghur6@GMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | Re: Date Formating |
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
On Feb 12, 10:53 am, Bill McKirgan <Bill.McKir...@gmail.com> wrote:
> Raghu,
>
> Try this out:
>
> data whua;
> length datestr $ 10;
> input datestr $;
> cards;
> 2008/02/13
> 2008/01/11
> 2008/01/10
> 2008/01/04
> 2008/01/01
> ;
> data dates; set whua;
> sasdate=input(datestr,yymmdd10. );
> put sasdate ;
> put sasdate yymmddN8.;
> put sasdate yymmdd10.
> //;
> run;
>
> --log--
>
> 17575
> 20080213
> 2008-02-13
>
> 17542
> 20080111
> 2008-01-11
>
> 17541
> 20080110
> 2008-01-10
>
> 17535
> 20080104
> 2008-01-04
>
> 17532
> 20080101
> 2008-01-01
>
> On Feb 12, 9:44 am, "ragh...@gmail.com" <ragh...@gmail.com> wrote:
>
>
>
> > I have data in following format yyyy/mm/dd
>
> > Proc print data=new1;
> > Run
>
> > Date
>
> > 2008/02/13
> > 2008/01/11
> > 2008/01/10
> > 2008/01/04
> > 2008/01/01
> > .
> > .
> > .
> > .
>
> > I want to remove the '/' so that it looks like 20080213 ( yyyymmdd)
>
> > Could you please let me know how do I solve this
>
> > Thanks,
> > Raghu- Hide quoted text -
>
> - Show quoted text -
Thanks a lot Bill
Regards,
Raghu
|