Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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

A fix for SAS 9.2 (TS1M0) for this issue is available at: