![]() | ![]() | ![]() | ![]() | ![]() |
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;
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | Base SAS | 64-bit Enabled AIX | 9 TS M0 | |
OpenVMS Alpha | 9 TS M0 | |||
64-bit Enabled HP-UX | 9 TS M0 | |||
HP-UX IPF | 9 TS M0 | |||
HP-UX | 9 TS M0 | |||
Linux | 9 TS M0 | |||
z/OS | 9 TS M0 | |||
64-bit Enabled Solaris | 9 TS M0 | |||
Solaris | 9 TS M0 | |||
Microsoft Windows 2000 Advanced Server | 9 TS M0 | |||
Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |||
Microsoft Windows 2000 Professional | 9 TS M0 | |||
Microsoft Windows XP Professional | 9 TS M0 | |||
Microsoft Windows NT Workstation | 9 TS M0 | |||
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | |||
Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | |||
Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | |||
Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | |||
Microsoft Windows 2000 Server | 9 TS M0 | |||
Tru64 UNIX | 9 TS M0 | |||
AIX | 9 TS M0 |