• Print |
• E-mail  |
• Bookmark

The dataset created by the ODS OUTPUT statement for the cross tabular
frequency table (CROSSTABFREQS) sometimes contains incorrect values for
one of the TABLE variables as well as the _TYPE_ variable. The problem
occurs when the TABLE contains numeric variables with a length less than
8 bytes.

Using the code below, the X value in the data set XTAB is always zero(0)
even though there are values of one(1) in the data set for X. The _TYPE_
values are also incorrect.

The workaround is to change the lengths of the TABLE variables (in this
case: X and Y) to 8.

  data test;
  length x y 4;
  /* workaround:    */
  /* length x y 8;  */
    input x y;
  cards;
  0 1
  1 0
  0 1
  0 1
  1 1
  0 0
  0 1
  ;

   ods output crosstabfreqs =  xtab;
  proc freq;
   tables x*y / out=new outpct;
  run;

  proc print data=xtab;
  title 'dset from ODS';
  run;

  proc print data=new;
  title 'dset from FREQ';
  run;

Operating System and Release Information