Usage Note 38430: Exporting BY groups from a SAS data set to multiple Microsoft Excel or text files
Programs are now available that enable you to export BY-group values from a SAS data set to multiple Excel Workbooks or text files.
The two programs:
- bygroupexporter9multifile.sas—used for exporting by groups to multiple Excel files
- bygroupexporter9multifiletxt.sas—used for exporting by groups to multiple text files
Click the Downloads tab to access the download location for these programs.
To export BY groups to multiple sheets in the same workbook, see SAS note 8874, "How to export BY groups from a SAS data set to multiple sheets in Excel."
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
*
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.
Two new programs are available that enable you to export BY groups from a SAS data set to either Excel files or text files. you can also modify the text exporter for other formats such as SPSS or STATA.
Type: | Usage Note |
Priority: | |
Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Excel
|
Date Modified: | 2010-10-25 13:34:36 |
Date Created: | 2010-01-18 15:43:19 |