I'm pulling date data from a Cube in character format, i.e.

2007 July
2007 August
2007 September


I'm trying to split this into a monyy7 date format using PROC SQL. Any
suggestions?

Dean,

You might be able to use something like:

data have;
  input have_date & $20.;
  cards;
2007 July
2007 August
2007 September
;

proc sql;
  create table want as
    select input(catt('1',
           substr(scan(have_date,2),1,3),
           scan(have_date,1)),date9.)
           as want_date
      format=3Dmonyy7.
        from have;
quit;

HTH,
Art
-------------
On Jul 25, 8:49=A0am, Dean <dean.par...@gmail.com> wrote:
> I'm pulling date data from a Cube in character format, i.e.
>
> 2007 July
> 2007 August
> 2007 September
>
> I'm trying to split this into a monyy7 date format using PROC SQL. Any
> suggestions?

That helps a lot - thanks very much Art



On Jul 26, 2:52=A0am, Arthur Tabachneck <art...@netscape.net> wrote:
> Dean,
>
> You might be able to use something like:
>
> data have;
> =A0 input have_date & $20.;
> =A0 cards;
> 2007 July
> 2007 August
> 2007 September
> ;
>
> proc sql;
> =A0 create table want as
> =A0 =A0 select input(catt('1',
> =A0 =A0 =A0 =A0 =A0 =A0substr(scan(have_date,2),1,3),
> =A0 =A0 =A0 =A0 =A0 =A0scan(have_date,1)),date9.)
> =A0 =A0 =A0 =A0 =A0 =A0as want_date
> =A0 =A0 =A0 format=3Dmonyy7.
> =A0 =A0 =A0 =A0 from have;
> quit;
>
> HTH,
> Art