topic Re: Numeric to Character and Concatenation in SAS Programming

Numeric to Character and Concatenation

BCNAV — Tue, 23 Jun 2020 17:39:05 GMT

I always mess this up....I have a year numeric variable and a month numeric variable. I would like to make a character variable called DateChar and have it look like:

2003-03

Note the leading 0.

Thanks

Re: Numeric to Character and Concatenation

Reeza — Tue, 23 Jun 2020 17:45:46 GMT

Why a character variable? There is a SAS format to display dates that way.

date_want = mdy(month, 1, year);
format date_want yymmd.;

*convert to character;
date_char = put(date_want, yymmd.);
date_char2 = catx('-', year, put(month, z2.));