Character to Date

[Costasg]

Hello all,

I am trying to convert a character date but what I am doing doesn't seem to work. I am attaching the file where date is of the form "1993-4" and the format is $6.

I am using this code to convert it to yyq6. but it doesn't work:

data want;

set example;

qtr=input(date,yyq6.);

format qtr yyq6.;

run;

Any suggestions?

[Tom · Accepted solution]

data want;

input date $6. ;

qtr=input(translate(date,'Q','-'),yyq6.);

format qtr yyq6.;

put (_all_) (=);

cards;

1993-4

run;

date=1993-4 qtr=1993Q4

[Altal]

OR this...

data want;

set example;

date1=tranwrd(date, "-", "q");

qtr  = input(date1,yyq6.);

format qtr yyq6.;

run;

[Jagadishkatam]

Please try the below code,

data have;

    input date $6.;

    new=input((tranwrd(date,'-','q')),yyq6.);

    format new yyq6.;

cards;

1993-4

;

proc print;

run;

Thanks,

Jagadish

[Costasg]

Many thanks to everybody!

All solutions work!