Hello, I have date fields in my output SAS dataset, which are formatted as MMDDYY10. (i.e., 07/15/2021). I need to be able to find a way to do a final format of these fields to a date format similar to MMDDYY10., but with the leading zeros suppressed for one-digit months and one-digit days (i.e., 7/15/2021 and 7/4/2021). I've looked at the COMPRESS function, and that doesn't seem to work. I used the MONTH, DAY, and YEAR functions to isolate those components and tried to concatenate them together via CATX. The result is a text version of the date, but if I go to convert that to a date format, I'll run into the same issue with MMDDYY10. as before. Is there a way to concatenate numbers with a delimiter, such as "/"? Otherwise, is there a better alternative for solving the issue? Please let me know. Thank you!
... View more