However, the issue is you're always merging merge1 (first data) with the new (latest) data, not to the last appended data. Change it to merge1. Also, a Proc append would be better, as its more efficient and doesn't need the conditional macro statement. proc append base=unemploy_merge data=&state force; run; More than one way to solve this issue.
... View more