The requirements in SAS Forecast Studio User's Guide state that the input data set must be a single SAS data set. To enable SAS Forecast Server to read a SAS data set, you can create a SAS program that reads your raw data into a SAS data set. Place your data set in a SAS library.
There is a short chapter about libraries in SAS Forecast Server Administrator's Guide. The chapter is titled: "Creating and Configuring Libraries." We recommend that you start by reading that chapter. Be sure to read it carefully.
If reading and following the directions in that chapter does not solve your issue, then try these tips:
Create a library
The easiest way to create a library and be able to access the data sets is to create an "Automatic environment library." The "Creating and Configuring Libraries" chapter contains a description and instructions for this type of library. With this type of library, there is no need to register tables.
Verify that the library is pre-assigned
If the library that you want is not displayed in SAS Forecast Studio, then make sure that the library is a pre-assigned library.
Put a LIBNAME statement in autoexec_usermods file
In SAS Forecast Studio, if the library is displayed but the data sets are not displayed, then you can specify the LIBNAME statement for that library in the autoexec_usermods file in the .../SASAPP/WorkspaceServer/ directory. Always make a backup copy of the autoexec_usermods file before editing.
Put a LIBNAME statement in the environment start-up code or in your SAS or server configuration files
Library declarations can be made by including LIBNAME statements in the start-up code for an environment or in your SAS or server configuration files. NOTE: Do not make any edits to the libraries_declaration.sas file in the SAS Forecast Studio projects directory. Also, do not use the project start-up code to specify the input libraries for a project. The timing of this assignment is not appropriate for input data since the Workspace Server connection has already been made. This information is also included in SAS Note 54702: "Requirements and best practices for SAS® Forecast Server."
If you are trying to create a library that points to tables in a database, then create a second library
When using data from a database, create a SAS library that points to the tables in the database. The data sets in this library can be read, but not updated. If SAS data sets from this library are not displayed in SAS Forecast Studio, then try this workaround. Create a second library and place a copy of the SAS data sets in that library. You can write a program that copies the SAS data sets from the first library and cleans the data. We recommend that you clean the data before bringing the data into SAS Forecast Server. Here is a SAS Note that tells about pre-processing your data.
SAS Note 54882: "The SAS® Forecast Studio New Project Creation wizard gives an "Unable to detect time interval ..." warning "
Check permissions
If the above tips do not solve the issue, then check permissions. Make sure that users have properly set read/write permissions on the library content folder.
For on-demand libraries, you must configure SAS Forecast Server so that users can access these libraries
By default, SAS Forecast Server restricts the use of metadata libraries that are manually assigned, automatic environment libraries, and configured environment libraries. You must configure SAS Forecast Server so that users can access these libraries. To enable access, see the section "Enable Expanded Support for Libraries" under "Creating and Configuring Libraries" in SAS Forecast Server Administrator’s Guide.
Verify whether data in SASHELP is displayed
If data sets (and column names) in SASHELP are displayed, but not data sets from other libraries, then perhaps those other libraries are not set up correctly.
If using SAS Forecast Studio for Desktop, create a folder
Create a folder under the {ForecastStudioDesktop}\Environments\Default\Libraries\ directory. Copy your data sets into the folder that you created. The name that you give to this folder should be displayed as a library in SAS Forecast Studio for Desktop. A common root directory for {ForecastStudioDesktop} is "C:\Users\{user ID}\ForecastStudioDesktop\".
Create a library in SAS Forecast Project Manager
Open SAS Forecast Project Manager. Select Help ► SAS Forecast Project Manager Help ► Libraries ► Create a New Environment Library. Follow the steps to create a new library. If your library is not displayed after following these steps, then set Assignment policy to Eager and Access level to Write.
Do not start a data set name with an underscore and do not use blanks in data set names.
In SAS Forecast Server, data set names that start with an underscore (_) or have embedded blanks in the data set name are not displayed in libraries in step 2 of New Project Wizard. The data set name must be a valid SAS name. For more information about SAS naming conventions, see SAS Language Reference: Concepts.
Do not use embedded blanks in variable names.
In SAS Forecast Server, if a variable name has embedded blanks, then no variables are displayed in step 3 of New Project Wizard.
If the "New Library" icon is disabled in SAS Forecast Project Manager
In SAS Forecast Project Manager, if the New Library icon is disabled, then follow these steps: Open SAS® Management Console. Under the Plug-ins tab, expand Configuration Manager ► SAS Application Infrastructure. Right-click Forecast Server
Try creating a library using SAS code
Example:
libname test 'C:\SAS\EMFS\Lev1\AppData\SASForecastServer14.1\Libraries\test'; libname sashelp1 'C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp'; DATA test.magnolia sashelp1.magnolia; INFILE 'C:\SAS\EMFS\Lev1\AppData\SASForecastServer14.1\Libraries\test\treedata.txt'; INPUT ScientificName $ 1-14 CommonName $ 16-32 MaximumHeight AgeBloom Type $ Color $; Run;
Library "test" is an automatic SAS Forecast Server Environment library that is configured on the Default SAS Forecast Server environment.
Library "sashelp1" is the actual path to the SASHELP library that surfaces in SAS Forecast Studio.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Forecast Server | Microsoft® Windows® for x64 | 14.1 | 9.4 TS1M3 | ||
Microsoft Windows 8 Enterprise 32-bit | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8 Enterprise x64 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8 Pro 32-bit | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8 Pro x64 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8.1 Enterprise 32-bit | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8.1 Enterprise x64 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8.1 Pro 32-bit | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 8.1 Pro x64 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows 10 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2008 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2008 R2 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2008 for x64 | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2012 Datacenter | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2012 R2 Datacenter | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2012 R2 Std | 14.1 | 9.4 TS1M3 | ||||
Microsoft Windows Server 2012 Std | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Enterprise 32 bit | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Enterprise x64 | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Home Premium 32 bit | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Home Premium x64 | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Professional 32 bit | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Professional x64 | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Ultimate 32 bit | 14.1 | 9.4 TS1M3 | ||||
Windows 7 Ultimate x64 | 14.1 | 9.4 TS1M3 | ||||
64-bit Enabled AIX | 14.1 | 9.4 TS1M3 | ||||
64-bit Enabled Solaris | 14.1 | 9.4 TS1M3 | ||||
HP-UX IPF | 14.1 | 9.4 TS1M3 | ||||
Linux for x64 | 14.1 | 9.4 TS1M3 | ||||
Solaris for x64 | 14.1 | 9.4 TS1M3 |
Type: | Usage Note |
Priority: | medium |
Date Modified: | 2019-02-15 07:54:43 |
Date Created: | 2015-08-13 15:01:05 |