Date:         Tue, 28 Aug 2007 16:24:56 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: Changing variables formats
Content-Type: text/plain; charset=ISO-8859-1

On Tue, 28 Aug 2007 15:55:02 -0300, Ricardo G Silva
<ricardosilva@SERASA.COM.BR> wrote:

>Dear Users,
>
>I have an unbalanced panel data set of firms. There is a date variable
>which is formated as ddmmyy10. It begins on 01/01/1999 and finishes at
>01/02/2007, that is, from 1 to 98 values. I cannot just do something like
>dt=day(date)||month(date)||year(date);
>since I will tranpose this table in a next step and I will nedd to keep
>the temporal order.
>So, I would like to create a new date2 variable relating each date in the
>date variable to a number of the date2 variable.
>
>Any idea about this issue?
>
>Thanks
>Ricardo Gon�alves Silva, M. Sc.
>Tecnologia de Cr�dito
>SERASA S.A.
>� (11) - 6847-8889
>? ricardosilva@serasa.com.br

If you want formatted date values which conform to chronological order, use
the YYMMDD format.

If you need to caclulate and use month indexes, offsets, etc., use the INTNX
and INTCK functions.