Change Source Table for existing Process Flow

[RPYee]

I have two tables that have identical columns.  One table is for the current month only (TBL_CURRENT) while the second table is the archive of all previous month data (TBL_STATIC).  I have a very standard query that polls the current data and summarizes it.  I want to copy the query and subsequent reports using the static table as the source.  In other programs I've used, it's been easy to simply change the reference from one to the other.  Is there a way to do this in SAS EG?  

Thanks for any help you can provide!

Rita Yee

Project Engineer

FedEx Global Trade Services

[VDD]

From what you have described you only need to change your table reference in the Proc SQL or datastep.  Maybe you will have to change your libname path if the archived data is not in the same location.

[NataljaK · Accepted solution]

1. In the Query Builder click right on the name of source file 2.Go to the Properties 3. In the Table Properties click to Change in the row Source