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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.