Well, I'm going to go out on a limb, and assume that the number within DATE is actually the 8-digit number that appears in your example (and not a SAS date). In that case:
length yyyy_c $ 4 mm_c dd_c $ 2;
date_c = put(date, 8.);
yyyy_c = date_c;
mm_c = substr(date_c, 5, 2);
dd_c = substr(date_c, 7, 2);
yyyy_n = input(yyyy_c, 4.);
mm_n = input(mm_c, 2.);
dd_n = input(dd_c, 2.);
If I'm wrong, and you actually have a SAS date stored within DATE, then use the suggestion about date functions.
... View more