topic Re: Character to numeric convertion in SAS Data Management

Character to numeric convertion

chirumalla — Tue, 18 Oct 2016 10:20:46 GMT

Hi,

My input data 2016- Jan (Charactor) I need output only month like 01(Numaric) in DI studio.

Ex: 2016- Jan -------> 01

2016- Feb-------->02

Please help me on my request.

Re: Character to numeric convertion

LinusH — Tue, 18 Oct 2016 10:22:52 GMT

Use the input() function, together with an appropriate date informat (see the Base SAS documentation).

Re: Character to numeric convertion

chirumalla — Tue, 18 Oct 2016 10:25:34 GMT

Yes, I have used Input() function but I couldn't able to get exact informat, please help me on informat.

Re: Character to numeric convertion

LinusH — Tue, 18 Oct 2016 10:30:49 GMT

What have you tried?

And talking about "exact". Thre's a space between the hyphen and the month name. You need to get rid of that first (compress()).

Re: Character to numeric convertion

chirumalla — Tue, 18 Oct 2016 10:33:59 GMT

Their is no space between hypen and month (2016-Jan). I tried most of informats.

Re: Character to numeric convertion

Kurt_Bremser — Tue, 18 Oct 2016 10:55:12 GMT

data want;
input date_char $;
date = input(scan(date_char,2,'-')!!scan(date_char,1,'-'),anydtdte8.);
format date date9.;
month = month(date);
cards;
2016-Jan
;
run;

do this in User Written Code

Re: Character to numeric convertion

chirumalla — Tue, 18 Oct 2016 11:41:14 GMT

Hi KurtBremser,

Thanks for your help, It's working for me. Great help.