Hi, I am trying to create a macro that will calculate the month-end dates between 2 dates. This is what I have so far, but it looks like I am missing something. Any help would be greatly appreciated. %macro MonthEndDataset(start_date, end_date, dataset_name); data &dataset_name; format month_end_date date9.; start_date = input("&start_date", date9.); end_date = input("&end_date", date9.); month_end_date = intnx('month', start_date, 0, 'e'); do while(month_end_date <= end_date); output; month_end_date = intnx('month', month_end_date, 1, 'e'); end; run; %mend MonthEndDataset; %MonthEndDates('01JAN2024'd, '08AUG2024'd); Here is the error message: ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid.
... View more