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
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).
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).
Dates are numeric and CATS is applied to character values..
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: