How to Import and Export Scenarios and Shocks in SAS Risk Factor Manager on Viya
SAS Risk Factor Manager on Viya is a powerful module that comes installed with your SAS Risk Solution. It is designed to help companies manage, simulate, and analyze risk factors across different scenarios and shocks. By facilitating the import and export of these scenarios, SAS Risk Factor Manager streamlines the process of risk management, allowing for a more robust and accurate financial risk assessment. The purpose of this post is to guide you through this import/export process at a high level, ensuring you can efficiently manage risk factors within your SAS Risk Solution.
Understanding Scenarios and Shocks
Before we dive into the technicalities, let's clarify what we mean by scenarios and shocks. In the context of financial risk management, a scenario represents a set of conditions that might affect the financial market, such as changes in interest rates or stock prices. A shock, on the other hand, is a sudden, unexpected event that can have a significant impact on the market, like a financial crisis. Managing these elements effectively is crucial for predicting and mitigating financial risks.
Importing Scenarios and Shocks
Importing scenarios and shocks into SAS Risk Factor Manager is a simple general import process. You can define scenarios, shocks, and sets in an external file (csv, xls, sasb7dat), and then import them via the user interface. SAS Risk Factor Manager supports various data formats, including expanded format, date-based format, and set format, catering to different needs and preferences. Let's highlight how the import process works:
- Specify the source location of your scenario/shock file (this can be from a server or your local machine)
- Select the file to import (for server imports, select from in-memory tables from caslibs you have access to. For local files, ensure the data file follows the format guidelines outlined in the SAS documentation.)
- Select import options (Specify additional details such as the as-of date, version, and how you wish to import the objects, as a standalone or part of a set)
Exporting Scenarios and Shocks
Exporting allows you to work with scenarios or shocks outside of SAS Risk Factor Manager. You can export to various formats, including .csv and .xlsx, though it's important to note that the export process does not support sets. Let's now highlight how the export process works:
- Specify the target location (decide between exporting to a server or downloading to a local machine)
- Select scenarios or shocks to export (choose all items you wish to export from the SAS Risk Factor Manager interface)
- Select export options (for server exports, select the CAS server and library, for local files, choose the file format and name)
Here are the file formats available in SAS Risk Factor Manager
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
To complete the full picture, here is a matrix showing which file types and object combinations are supported during the import/export process
Conclusion
Importing and exporting scenarios and shocks in SAS Risk Factor Manager on Viya are essential skills to have for effective risk management. By following the steps outlined above, you can ensure that your risk factors and shocks are accurately tested and reflected in your risk models, allowing for better decision-making and risk assessment.
For a more detailed explanation and specifics of each file format, be sure to check the official SAS documentation at https://support.sas.com/en/documentation.html.
Find more articles from SAS Global Enablement and Learning here.
