Help using Base SAS procedures

Character variable to Date variable

Reply
Frequent Contributor
Frequent Contributor
Posts: 94

Character variable to Date variable

Hello,

I have a character variable (DateVar) which I want to convert to date.

data have;

DateVar='November 2014';

run;

The output dataset should also show the value of DateVar as November 2014 but as a date variable.

Any suggestions?

Thanks.

Esteemed Advisor
Posts: 6,270

Re: Character variable to Date variable

I'd split the string with SCAN and then use the FINDW function to determine the month out of a reference string.

I doubt that a single format could be made that handles the display in one step. You may have to create a separate character variable for display (or keep the original column).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Valued Guide
Posts: 854

Re: Character variable to Date variable

If you need the display to look like this I would keep this column as your display, you can use substr() to cut up the format and then go with the MONYY. format for any calculations that need done.

Valued Guide
Posts: 854

Re: Character variable to Date variable

data have;

DateVar='November 2014';

run;

data prep;

set have;

month = substr(datevar,1,3);

year = scan(datevar,2,' ');

run;

data want;

format new_date monyy7.;

set prep;

new_date = input(put(trim(month)||trim(year),$char7.),monyy7.);

run;

Frequent Contributor
Frequent Contributor
Posts: 94

Re: Character variable to Date variable

Thank you, all.

Ask a Question
Discussion stats
  • 4 replies
  • 250 views
  • 3 likes
  • 3 in conversation