Dear all, I encounter a problem how to dynamically create view on the datasets which are split by half-year. It starts from ABC_2011H1, ABC_2011H2, ..., ABC_2015H1, etc. If today is 2015.05.31, I would like to create view to append from ABC_2011H1 to ABC_2015H1, like the following: proc sql; create view ABC as select * from ABC_2011H1 union all select * from ABC_2011H2 union all ... ... select * from ABC_2015H1 ; quit; I would like to make a macro/do-loop to achieve it. It can join based on date (upper half year/lower half year), not by hard-coding. Please help. Thank you.
... View more