Problem Note 18993: Certain date formats generate error with PROC EXPORT when exporting to
SPSS, STATA, and JMP files
Variations on certain date format names are not trapped as date when
writing to SPSS, STATA, JMP, etc with PROC EXPORT, and result in an
error. Format names that might cause a problem include YYMMxw., YYQxw.,
YYQRxw., MMYYxw., MMDDYYxw., DDMMYYxw. and YYMMDDxw.
The first data set, TEST1, yields no error message when sent to PROC
EXPORT. Exporting the second data set, TEST2 (identical except
the variable is formatted as YYMMDDN8.), does generate the error
message.
data test1;
x1='01oct2006'd;
format x1 date9.;
put _all_;
run;
proc export data=test1 dbms='DTA'
outfile='c:\temp\test1.dta' replace;
run;
data test2;
x2='01oct2006'd;
format x2 yymmddn8.;
put _all_;
run;
proc export data=test2 dbms='DTA'
outfile='c:\temp\test2.dta'replace;
run;
ERROR: The format YYMMDDN was not found or could not be loaded.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP3 | 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 |
| Date Modified: | 2006-12-11 15:58:01 |
| Date Created: | 2006-11-16 13:21:16 |
