Usage Note 12904: How to use the MULTILABEL and NOTSORTED options with PROC FORMAT
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
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 | |
*
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: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> FORMAT
|
Date Modified: | 2004-12-08 07:59:22 |
Date Created: | 2004-07-15 12:01:22 |