SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| 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 | ||