Hi guys. I really appreciated that you guys are trying to help me with this problem. It's quite messy but it's what I have to deal with. When I posted this question, I didn't realize I provided less information than my dataset had given to me. Anyways, I wrote some code that worked fine for me. For anyone who's interested, that's what I used: reformat_date = input(compress(date, '.'), anydtdte13.); reformat_date_2 = input(date, yymmdd10,); format reformat_date reformat_date_2 date9.; It didn't convert all dates but it did most of the work. I did other modifications too.
... View more