As far as I know you can't.  You can merge the data together - I don't see why this is a big issue for you? data want; merge report1 report2 (rename=(date=date2 turnover=turnover2...)) report3 (rename=(date=date3...)); by ...; run; There are missing parts there as I don't have full information, maybe you want to merge by _n_, if so you need to add that as a variable to the data. ... View more