Problem Note 20501: "Advisor Error: SAS Formats for this table could not be located" appears when creating a data source
When creating a data source in SAS® Enterprise Miner™, you might receive the following error:
Advisor Error: SAS Formats for this table could not be located.
Make sure their location is in the format search path.
You can add this code to the project start-up code.
The problem occurs if formats (or informats) are assigned to variables in the data set, and those formats are not available to SAS Enterprise Miner. (Note that specifying the SAS option NOFMTERR in the Project Start Code does not correct the problem.)
To circumvent the problem, either point to the location of the formats (or informats), or disassociate the formats (or informats) from the data.
- Disassociate the format (or informat). One reason to disassociate is that you no longer have access to the format catalog. You can remove the format (or informat) from the variable in that data set using PROC DATASETS.
Example:
proc datasets lib=mylibrary;
modify mydata;
format myvariable;
informat myvariable;
quit;
In the above example, the format (and informat) is removed only from the variable MYVARIABLE. All other variables maintain their format (and informat). You can also specify FORMAT _ALL_ within DATA step code to remove formats from all variables in the data set. FORMAT _ALL_ removes not only user-defined formats, but also removes SAS specific formats (such as date formats). Likewise, you can specify INFORMAT _ALL_.
Example:
data mylibrary.mydata;
set mylibrary.mydata;
format _all_;
informat _all_;
run;
For more information about formats, see Base SAS documentation.
Operating System and Release Information
SAS System | SAS Enterprise Miner | Microsoft Windows XP Professional | 5.3 | | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 5.3 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 5.3 | | 9.1 TS1M3 | |
Solaris for x64 | 5.3 | | 9.1 TS1M3 | |
Linux | 5.3 | | 9.1 TS1M3 | |
HP-UX IPF | 5.3 | | 9.1 TS1M3 | |
64-bit Enabled AIX | 5.3 | | 9.1 TS1M3 | |
AIX | 5.3 | | 9.1 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.
Type: | Problem Note |
Priority: | medium |
Topic: | Analytics ==> Data Mining
|
Date Modified: | 2017-07-12 09:28:34 |
Date Created: | 2007-07-03 08:11:35 |