topic Re: Character to Date in SAS Procedures

Character to Date

Costasg — Wed, 02 Oct 2013 13:11:02 GMT

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?

Re: Character to Date

Tom — Wed, 02 Oct 2013 13:50:30 GMT

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

Re: Character to Date

Altal — Wed, 02 Oct 2013 13:53:31 GMT

OR this...

data want;

set example;

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

qtr = input(date1,yyq6.);

format qtr yyq6.;

run;

Re: Character to Date

Jagadishkatam — Wed, 02 Oct 2013 13:55:16 GMT

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

Re: Character to Date

Costasg — Wed, 02 Oct 2013 20:58:03 GMT

Many thanks to everybody!

All solutions work!