As of the Viya stable 2023.11 release, you have the option to change the default library for the writing of temporary output tables when executing a flow in SAS Studio. This new option only applies to SAS Studio Flows.
By default, the WORK library is used but you now have the option to set a different library for these temporary tables. You can set this option for all SAS Studio flows you create or set it for a single SAS Studio flow.
In SAS Studio, select Options → Preferences from the menu. Select Tables to view the table preference options. The newly added section is Default Output Libraries.
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
The application default is the WORK SAS library. Select the radio button for Output library location and then select and navigate to the library you want to set as the new default for SAS Studio Flows.
Click Save to save the default output library selection. This sets the default output library for all your SAS Studio Flows.
Open the SAS Studio Flow where you want to set a different default output table library option. On the right-hand side of the flow, select to open the Properties pane for the flow.
In the Default output library for intermediate tables section, the application default is the WORK SAS library. Select the radio button for Output library location and then select and navigate to the library you want to set as the new default for SAS Studio Flows.
Save the flow to save the change to the properties. This sets the default output library just for this SAS Studio Flow.
You can now change the location where temporary output tables are written when executing a SAS Studio Flow. For more information, refer to the documentation.
Find more articles from SAS Global Enablement and Learning here.
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 16. Read more here about why you should contribute and what is in it for you!
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.