Proc Format difference between v9-1 and v9-2

From sasCommunity

Jump to: navigation, search

This is from my BenchMark programs testing Proc Format.

Contents

[edit] Program showing Proc Freq values

%let Libname = sashelp;
%let Memname = ASSCMGR;
%let Name    = SUCCCARD;
%let Ratio   = 0.0199004975;

Proc Print data = &Libname..&Memname.;

Proc Freq data   = &Libname..&Memname.;
          tables   &Name.
                 / list missing noprint
             out = Freq;
Proc Print data = Freq;
run;

[edit] Listing showing Proc Freq values

Obs    SUCCCARD    COUNT    PERCENT

 1                    1      0.2488
 2      0:1[]        16      3.9801
 3      0:1         103     25.6219
 4      0:m[]         9      2.2388
 5      0:m         195     48.5075
 6      1:1[]         7      1.7413
 7      1:1          62     15.4229
 8      1:m           9      2.2388

note: [] is used to represent a special character in the data.

The above data set: Freq, is used to generate the following proc format statements.

[edit] log v9.1.3, SP4

1         + Proc Format library = work;
2         + title3 LibHelp.ASSCMGR.SUCCCARD;
3         + value $SUCCCARD_
4         + ''=1
5         + '0:1'=2
6         + '0:1'=3
7         + '0:m'=4
8         + '0:m'=5
9         + '1:1'=6
10        + '1:1'=7
11        + '1:m'=8
12        + ;
NOTE: Format $SUCCCARD_ has been output.

[edit] log v9.2

1         + Proc Format library = work;
2         + title3 LibHelp.ASSCMGR.SUCCCARD;
3         + value $SUCCCARD_
4         + ''=1
5         + '0:1'=2
6         + '0:1'=3
7         + '0:m'=4
8         + '0:m'=5
9         + '1:1'=6
10        + '1:1'=7
11        + '1:m'=8
12        + ;
ERROR: These two ranges overlap: 0:1-0:1 and 0:1-0:1 (fuzz=0).
ERROR: These two ranges overlap: 0:m-0:m and 0:m-0:m (fuzz=0).
ERROR: These two ranges overlap: 1:1-1:1 and 1:1-1:1 (fuzz=0).
NOTE: The previous statement has been deleted.

--macro maven == the radical programmer 12:03, 24 April 2008 (EDT)

Personal tools