SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 12904: How to use the MULTILABEL and NOTSORTED options with PROC FORMAT

DetailsOutputAboutRate It

If the MULTILABEL and NOTSORTED options are used to create a format, then the MLF, PRELOADFMT, and ORDER=DATA options must be used in the CLASS statement of the procedure that is using the format.

This functionality is available only in SAS® 9 and beyond.

The example below illustrates this.

data carsurvey;
   input Rater Age Progressa Remark Jupiter Dynamo;
   datalines;
   1 38 94 98 84 80
   2 49 96 84 80 77
   3 16 64 78 76 73
   4 27 89 73 90 92
   77 61 92 88 77 85
   78 24 87 88 88 91
   79 18 54 50 62 74
   80 62 90 91 90 86
   ;
run;

proc format;
   value agefmt (multilabel notsorted)
        15 - 29 = 'Below 30 years'
        30 - 50 = 'Between 30 and 50'
        51 - high = 'Over 50 years'
        15 - 19 = '15 to 19'
        20 - 25 = '20 to 25'
        25 - 39 = '25 to 39'
        40 - 55 = '40 to 55'
        56 - high = '56 and above';
run;

proc tabulate data=carsurvey format=10.;
   class age / mlf preloadfmt order=data;
   var progressa remark jupiter dynamo;
   table age all, n all='Potential Car Names'*(progressa remark
         jupiter dynamo)*mean;
   title1 "Rating Four Potential Car Names";
   title2 "Rating Scale 0-100 (100 is the highest rating)";
   format age agefmt.;
run;


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SAS64-bit Enabled AIX9 TS M0
OpenVMS Alpha9 TS M0
64-bit Enabled HP-UX9 TS M0
HP-UX IPF9 TS M0
HP-UX9 TS M0
Linux9 TS M0
z/OS9 TS M0
64-bit Enabled Solaris9 TS M0
Solaris9 TS M0
Microsoft Windows 2000 Advanced Server9 TS M0
Microsoft Windows 2000 Datacenter Server9 TS M0
Microsoft Windows 2000 Professional9 TS M0
Microsoft Windows XP Professional9 TS M0
Microsoft Windows NT Workstation9 TS M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9 TS M0
Microsoft Windows Server 2003 Standard Edition9 TS M0
Microsoft Windows Server 2003 Enterprise Edition9 TS M0
Microsoft Windows Server 2003 Datacenter Edition9 TS M0
Microsoft Windows 2000 Server9 TS M0
Tru64 UNIX9 TS M0
AIX9 TS M0
* 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.