SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 33464: Applying a format or informat in the Viewtable window might return an error

DetailsHotfixAboutRate It

When applying formats or informats to a table using the Viewtable window, you might receive an error when the available format/informat list is displayed. The error does not prevent the formatted/informatted data from being displayed.

Creating a FORMATS catalog in the WORK library removes the first error message: ERROR: Catalog WORK.FORMATS does not exist. However, if user-defined formats/informats exist in the FORMATS catalog, then this second error message continues to appear: By variables are not properly sorted

The log below contains messages similar to what you might receive in these situations:

1    proc sql;
2    create view work._qwffmt as select fmtname from dictionary.formats where source='C';
NOTE: SQL view WORK._QWFFMT has been defined.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds


3    proc format lib=work.formats fmtlib cntlout=work._fmtdesc noprint;
4    run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

ERROR: Catalog WORK.FORMATS does not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK._FMTDESC may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.


5    data work._fmtdesc2;
6    set work._fmtdesc;
7    by fmtname;
8    if first.fmtname;
9    run;

ERROR: BY variable fmtname is not on input data set WORK._FMTDESC.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK._FMTDESC2 may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for 64-Bit Itanium-based Systems9.2 TS1M09.2 TS2M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.2 TS1M09.2 TS2M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.2 TS1M09.2 TS2M0
Microsoft Windows XP 64-bit Edition9.2 TS1M09.2 TS2M0
Microsoft® Windows® for x649.2 TS1M09.2 TS2M0
Microsoft Windows Server 2003 Datacenter Edition9.2 TS1M09.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition9.2 TS1M09.2 TS2M0
Microsoft Windows Server 2003 Standard Edition9.2 TS1M09.2 TS2M0
Microsoft Windows XP Professional9.2 TS1M09.2 TS2M0
Windows Vista9.2 TS1M09.2 TS2M0
64-bit Enabled AIX9.2 TS1M09.2 TS2M0
64-bit Enabled HP-UX9.2 TS1M09.2 TS2M0
64-bit Enabled Solaris9.2 TS1M09.2 TS2M0
HP-UX IPF9.2 TS1M09.2 TS2M0
Linux9.2 TS1M09.2 TS2M0
Linux for x649.2 TS1M09.2 TS2M0
OpenVMS on HP Integrity9.2 TS1M09.2 TS2M0
Solaris for x649.2 TS1M09.2 TS2M0
* 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.