topic Re: Convert character to date9. in SAS Programming

Convert character to date9.

SasStatistics — Thu, 01 Dec 2022 15:07:58 GMT

I have data of the following form:

where the period has the type: character with length 9.

and I would like to convert it to date9. so that 202203 is converted to 01MAR2022 and 202204 to 01APR2022.

Any suggestions are much appreciated.

PaigeMiller — Thu, 01 Dec 2022 17:59:43 GMT

data want;
    set have;
    new_period=input(period,yymmn6.);
    format new_period date9.;
run;

Tom — Thu, 01 Dec 2022 15:44:01 GMT

Use INPUT() to make a new numeric variable with date values. The YYMMN informat will recognize those strings.

date=input(period,yymmn6.);
format date date9.;