merging two tables

[fergieis]

In that case, it might be useful to open/import one, and use proc append with the “force” option to append the 2nd file to the first.

[Tom]

Perhaps it is as simple as not asking SQL to combine the variables by their ORDER in the dataset, but instead to match them by their NAME?

      union all corresponding

Why use SQL at all?

data combined_years;
  set FY20 FY21;
run;