Never mind... it's not productive going round and round about whether I have a SAS dataset or whether I have a date formatted variable, getting feedback on how to parse character variables, and nothing addressing the actual question of how to extract a month or year from the ISO date. The format statement was to indicate the 2 variables being compared. It was not a statement that I am creating those variables. I don't know how to show you the date field without the screenshot, but also why do you need to see it when it's simply an ISO date? Anyway, this has been super unhelpful so I'll go elsewhere to solve the problem. Oh, and I figured out the solution. TSTART = PUT(trtstartdate,E8601DA.);
tmonth = substr(tstart,6,2);
tyear = substr(tstart,1,4);
... View more