Problem Note 13415: Generating output with the CSV tagset may cause performance problems
When generating output with the CSV and the CSVALL tagsets in SAS 9.12
and SAS 9.13, performance problems may exist.
This may result in out of memory errors, or increase CPU and elapsed
times.
The CSV tagset has to determine whether a data value is a string, which
must be quoted, or a number, which is not quoted. The algorithm can be
undesirably slow in certain situations, especially when the data is all
numeric. The fix for this can be added by updating the tagset.
The updated tagset also includes additional enhancements to the CSV
destination for SAS 9.1.3. The currency symbol is no longer displayed
by default when the DOLLARw.d format has been applied to a variable. The
updated tagset provides the flexibility of choosing whether to display
the symbol or not as well as additional options such as quoting and the
delimiter to use.
For an updated copy of the tagset with the fix, see the URL below.
http://support.sas.com/rnd/base/topics/odsmarkup/
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows NT Workstation | 9.1 TS1M2 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows 2000 Professional | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows 2000 Server | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | 9.2 TS1M0 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | 9.2 TS1M0 |
64-bit Enabled Solaris | 9.1 TS1M2 | 9.2 TS1M0 |
z/OS | 9.1 TS1M2 | 9.2 TS1M0 |
Linux | 9.1 TS1M2 | 9.2 TS1M0 |
HP-UX IPF | 9.1 TS1M2 | 9.2 TS1M0 |
64-bit Enabled HP-UX | 9.1 TS1M2 | 9.2 TS1M0 |
OpenVMS Alpha | 9.1 TS1M2 | 9.2 TS1M0 |
64-bit Enabled AIX | 9.1 TS1M2 | 9.2 TS1M0 |
Tru64 UNIX | 9.1 TS1M2 | 9.2 TS1M0 |
*
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.
Type: | Problem Note |
Priority: | medium |
Topic: | SAS Reference ==> ODS (Output Delivery System)
|
Date Modified: | 2008-01-21 15:13:08 |
Date Created: | 2004-09-24 11:08:10 |