Hi, I am reading through the solution for Level 2 Practice in Lesson 4 Creating New Columns with Character and Date Functions. In the original file, pg1.eu_occ, the type for "YearMon" is character. Hence after substring the Year and Month, should they be character type too? But does it not need to be in numeric format for the MDY function to work? Can anyone please help on this, thank you so much! data eu_occ_total;
set pg1.eu_occ;
Year=substr(YearMon,1,4);
Month=substr(YearMon,6,2);
ReportDate=MDY(Month,1,Year);
Total=sum(Hotel,ShortStay,Camp);
format Hotel ShortStay Camp Total comma17.
ReportDate monyy7.;
keep Country Hotel ShortStay Camp ReportDate Total;
run;
... View more