How to add zero for the date

[valerieyim]

Hi SAS Communities,

The original data of Bithmonth and Birthday does not have a leading zero, so if I code in the following way, when I put FORMAT BirthDt MMDDYY10.; some of the data will show up ****. Do you mind telling me how I can add leading zero in my code, please?

Here is my code:

	BirthDt = 	CATS(BirthYear, BirthMonth, BirthDay);
	

Thanks,

Valerie

[Kurt_Bremser · Accepted solution]

CATS is a character function, but SAS dates are numeric. SAS dates are a count of days with 1960-01-01 as day zero.

To create a date from separate year/month/day values, you use the MDY function:

BirthDt = mdy(BirthMonth,BirthDay,BirthYear);

Then the format will work (for reasonable values of year).

[PeterClemmensen]

Dates are numeric and CATS is applied to character values..