Usage Note 5025: New variables contain formatted values in ONEWAYLIST and ONEWAYFREQS data sets
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
| 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 |