Prior to SAS 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 SAS 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 is shown in the Full Code tab.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	Microsoft Windows NT Workstation	8.2 TS2M0
		Windows Millennium Edition (Me)	8.2 TS2M0
		Microsoft Windows 95/98	8.2 TS2M0
		Microsoft Windows 2000 Professional	8.2 TS2M0
		Microsoft Windows 2000 Server	8.2 TS2M0
		OpenVMS VAX	8.2 TS2M0
		Microsoft Windows 2000 Advanced Server	8.2 TS2M0
		Microsoft Windows 2000 Datacenter Server	8.2 TS2M0
		Solaris	8.2 TS2M0
		OS/2	8.2 TS2M0
		IRIX	8.2 TS2M0
		64-bit Enabled Solaris	8.2 TS2M0
		z/OS	8.2 TS2M0
		ABI+ for Intel Architecture	8.2 TS2M0
		Linux	8.2 TS2M0
		HP-UX	8.2 TS2M0
		64-bit Enabled AIX	8.2 TS2M0
		OpenVMS Alpha	8.2 TS2M0
		CMS	8.2 TS2M0
		64-bit Enabled HP-UX	8.2 TS2M0
		AIX	8.2 TS2M0
		Tru64 UNIX	8.2 TS2M0

* 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.

This code removes the F_variable variable from the ONEWAYFREQS output.

---

ods path (prepend) work.templat(update);
proc template;
   edit base.freq.onewayfreqs;
      column Line FVariable FListVariable Variable Frequency TestFrequency    
             Percent TestPercent CumFrequency CumPercent;   
      edit FVariable;
         drop=yes;
      end;
   end;
run;

ods output onewayfreqs=new;

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

ods listing;

proc print data=new;
run;

New variables contain formatted values in ONEWAYLIST and ONEWAYFREQS data sets.

Type:	Usage Note
Priority:
Topic:	Analytics ==> Descriptive Statistics SAS Reference ==> Procedures ==> FREQ Analytics ==> Nonparametric Analysis Analytics ==> Longitudinal Analysis Analytics ==> Categorical Data Analysis Analytics ==> Exact Methods

Date Modified:	2003-06-20 10:16:28
Date Created:	2001-05-21 13:40:38