Usage Note 40181: Why user-defined formats might not be available to select in SAS® Information Map Studio
 |  |  |  |
If you have followed the instructions in Usage Note 40103: Frequently asked questions about making user-defined formats available in a SAS Business Intelligence deployment, but you still cannot see the formats in SAS Information Map Studio, then review the following possible causes.
| Possible Cause | Possible Resolution or Next Steps | |
|---|---|---|
| After modifying the applicable CFG file by following the instructions in Usage Note 40103, did you restart the object spawner? | Restart your object spawner so that you are working with a new SAS session. | |
| Is the table selected for the information map associated with the same SAS® Application Server to which you defined the format catalog? | Both the table and the catalog must be defined in the same SAS Application Server. For example, if your table is associated with SASApp, but your user-defined format catalog is associated with SASApp2, then SAS Information Map Studio cannot access the formats. To resolve this issue, you can either select a table from the SAS Application Server that is associated with the format catalog, or follow the instructions in Usage Note 40103 to make the user-defined formats available to the server that is associated with the table. | |
Is your FMTSEARCH option correctly set in the sasv9.cfg or sasv9_usermods.cfg configuration file? |
In SAS® Enterprise Guide®, submit the following code in the same SAS Application Server context in which the formats catalog is defined. For example,you might connect to the SASApp server. proc options option=fmtsearch; run;
Here are some sample results from SAS Enterprise Guide.
If the library that contains your catalog is not listed, then refer back to Usage Note 40103. |
|
| Can you successfully submit a LIBNAME statement for the location of the format catalog? |
SAS Information Map Studio uses a pooled workspace server by default. In SAS Enterprise Guide, log on with the credentials for the pooled workspace server (usually, sassrv). When connected to the SAS Application Server in which the formats catalog is defined, submit the following code, substituting your path information. libname library "<sas-config-dir>\Lev1\SASApp\SASEnvironment\SASFormats"; run;
If you see the following errors, then contact your administrator to request operating-system access to the location.
ERROR: User does not have appropriate authorization level for library LIBRARY.
ERROR: Error in the LIBNAME statement.
|
|
| Can you read the contents of the formats catalog, and does the catalog contain formats? |
SAS Information Map Studio uses a pooled workspace server by default. In SAS Enterprise Guide, log on with the credentials for the pooled workspace server (usually, sassrv). When connected to the SAS Application Server in which the formats catalog is defined, submit the following code, substituting your path information. Run PROC CATALOG for each of the catalogs specified in your FMTSEARCH option. In this example, the catalog is named libname library "<sas-config-dir>\Lev1\SASApp\SASEnvironment\SASFormats"; proc catalog cat=library.formats; contents; quit; run;
If the LIBNAME statement is successfully submitted but no formats are listed, then refer back to Usage Note 40103. If you see the following error, then contact your administrator to request operating-system access to the catalog.
ERROR: User does not have appropriate authorization level for file LIBRARY.FORMATS.CATALOG
|
|
| Are you using an OLAP data source for the information map? | SAS Information Map Studio does not enable you to select user-defined formats for OLAP data sources. For more information, see Usage Note 18347: User-defined formats are not available to select in SAS Information Map Studio for OLAP measures. | |
| Does the format catalog contain user-defined formats that match the type of data item that you have selected? | For example, if you have selected a character data item, then only character formats are displayed. If your catalog does not have any character formats, then the list of formats is blank in SAS Information Map Studio. See the previous suggestions for how to verify the contents of a format catalog. | |
| Can you launch a workspace server from SAS Information Map Studio? | In order to see formats, you must be able to launch either a pooled workspace server or a standard workspace server. Attempt to test the information map. If the test fails, then contact your system administrator or SAS Technical Support. Inability to launch a workspace server is a separate issue. | |
Did you make changes to the sasv9.cfg or sasv9_usermods.cfg configuration file to point to a different catalog or location? |
If SAS Information Map Studio was open when you made changes, you must restart SAS Information Map Studio in order for the changes to be visible. | |
| Is the library that contains the input data source allocated with the META engine? | Formats are not supported if the library is allocated with the META engine. For more information, see Usage Note 43378: META Libname Engine does not support SAS Catalog access. |
If you have reviewed the remedies in this note and you still cannot see user-defined formats in SAS Information Map Studio, then turn on workspace server logging as explained in Usage Note 34567: Capturing the PROC SQL code that is generated by SAS® Web Report Studio and SAS Information Map Studio when using version 4.2 or later. Then, attempt to access user-defined formats, and send the resulting log to SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Information Map Studio | Microsoft Windows 2000 Advanced Server | 3.1 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows XP Professional | 3.1 | 9.1 TS1M3 SP4 | ||||
| Windows Vista | 3.1 | 9.1 TS1M3 SP4 | ||||
| Windows Vista for x64 | 3.1 | 9.1 TS1M3 SP4 | ||||
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> Information map Data Management ==> Data Sources ==> Metadata Data Management ==> Data Sources ==> SAS catalogs Data Management ==> Manipulation and Transformation ==> User Written Formats SAS Reference ==> Formats ==> Formats SAS Reference ==> System Options ==> FMTSEARCH= System Administration ==> Servers ==> Metadata |
| Date Modified: | 2010-07-05 19:50:33 |
| Date Created: | 2010-07-01 14:50:03 |