topic Re: Changing string date to date variable in SAS Enterprise Guide

Changing string date to date variable

Sean_OConnor — Fri, 09 Nov 2018 10:52:03 GMT

Folks,

I have a String variable in the following format - 2010M01.

I would like to convert it to a sas date variable.

Any help would be great.

Kind regards,

Sean

Re: Changing string date to date variable

RW9 — Fri, 09 Nov 2018 11:01:00 GMT

Use:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000199309.htm

Re: Changing string date to date variable

Sean_OConnor — Fri, 09 Nov 2018 11:11:32 GMT

Hi RV9,

I'm still running into some trouble on this.

I've attached a sample of code as an example;

Re: Changing string date to date variable

FreelanceReinh — Fri, 09 Nov 2018 11:11:44 GMT

Hi @Sean_OConnor,

It's a bit odd that there is a SAS format to write such values (see link provided by RW9), but no informat counterpart. The YYMMN. informat comes close, but requires us to remove the "M":

data test;
m='2010M01';
d=input(compress(m,'M'),yymmn6.);
format d date9.;
run;

proc print data=test;
run;

Note that the resulting date value defaults to the first day of the month.

Re: Changing string date to date variable

Kurt_Bremser — Fri, 09 Nov 2018 11:14:19 GMT

Remove the M, and use the yymmn informat:

data test;
x1 = input(compress('2010M01','M'),yymmn6.);
format x1 yymmddd10.;
run;