topic Re: Change Source Table for existing Process Flow in SAS Enterprise Guide

Change Source Table for existing Process Flow

RPYee — Fri, 14 Dec 2018 16:12:04 GMT

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

Re: Change Source Table for existing Process Flow

VDD — Fri, 14 Dec 2018 16:23:21 GMT

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.

Re: Change Source Table for existing Process Flow

NataljaK — Mon, 17 Dec 2018 13:47:21 GMT

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