topic Re: How to add zero for the date in SAS Programming

How to add zero for the date

valerieyim — Thu, 10 Dec 2020 15:09:58 GMT

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

Re: How to add zero for the date

Kurt_Bremser — Sun, 08 Nov 2020 07:40:16 GMT

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).

Re: How to add zero for the date

PeterClemmensen — Sun, 08 Nov 2020 07:41:01 GMT

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