• Print |
• E-mail  |
• Bookmark

Previous to release 8.2 the output data sets created by PROC FREQ and
the output objects ONEWAYLIST and ONEWAYFREQS did not contain the
original variable's value. Instead they contained the formatted value of
the TABLES variable. Beginning in release 8.2, the variable retains its
name, type and format in the output data set.

In addition there is now a variable, called F_<nameoftablesvar>
containing the formatted value which is a copy of the displayed value.
For example, if variable X has a value of 1 and is formatted to 'YES'
then F_X will be character with a length of 3 (or the longest length
within that format).

In the TABLE templates for ONEWAYLIST and ONEWAYFREQS these new
variables are listed as FVARIABLE and FLISTVARIABLE.

Sample code to remove the FVARIABLE from the output data set created
by the ONEWAYFREQS object follows:

ods path (prepend) work.templat(update);
proc template;
 edit base.freq.onewayfreqs;
   edit FVariable;
     drop=yes;
    end;
 end;
run;
ods output onewayfreqs=new;

proc freq data=sashelp.class;
 tables age;
run;

proc print data=new;run;

Operating System and Release Information