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 name and select Properties. Select the Settings tab. Select Forecast Server on the left, and then on the right side, go to the Forecast Server > Library Access section. Change the settings there from Ignore to Assign. After making that change, restart the server on which SAS Forecast Server resides.

• 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.

Operating System and Release Information

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

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Information about libraries in SAS Forecast Studio when the library or data sets are not displayed in SAS Forecast Studio

Type:	Usage Note
Priority:	medium

Date Modified:	2019-02-15 07:54:43
Date Created:	2015-08-13 15:01:05