Problem Note 40535: Using PROC EXPORT to write to a fileref assigned with the FILENAME FTP engine generates errors if the remote file already exists
If you use PROC EXPORT to write to a fileref assigned with the FILENAME
FTP engine, errors are generated if the remote file already exists. The errors will be similar to the following:
Segmentation Violation In Task [ DATASTEP ]
0xf4a4(?)
dsefrec+0x13c
dsepfp+0x53c
CODEGEN(0x700000001b1ca20, 0x700000000619520, 0x73019087a0)+0x2c8
vgexec+0x5c
dsxxexc+0xa8
dsxxexc+0x38 -- bridge stub
dsexec+0x48
sasds+0x3e8
vvtentr+0xf0
_uc_trampoline+0xfffffffffffffffc
The same PROC EXPORT code will run correctly if the remote file does
not exist.
As a workaround, a second FILENAME FTP statement may be used to delete the remote file programmatically before running PROC EXPORT.
Here is an example:
filename KILL ftp host="remote.host.com" user="<user>" pass="<password>" lrecl=32768
dir rcmd="dele /full/path/to/remote/file" debug ;
data _NULL_;
infile KILL ;
input ;
run ;
This problem will be fixed in a future release of SAS® software.
Operating System and Release Information
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| HP-UX IPF | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Linux | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Linux for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| OpenVMS on HP Integrity | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Solaris for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 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.
If you use PROC EXPORT to write to a fileref that has been assigned with the FILENAME FTP engine, errors are generated if the remote file exists. The code runs correctly if the remote file does not already exist.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Common Programming Tasks ==> Reading and Writing External Data ==> Export Wizard
Common Programming Tasks ==> Reading and Writing External Data ==> with PROC EXPORT
|
| Date Modified: | 2010-08-06 17:39:20 |
| Date Created: | 2010-08-06 10:00:01 |
