SUPPORT / SAMPLES & SAS NOTES
Problem Note 18913: PROC EXPORT to JMP® creates numeric fields with 2 decimal places
 |  |  |  |  |
When using PROC EXPORT in SAS® 9.1.3 to create a .jmp file, any numeric fields will be created with two decimal places.
Sample code:
data q;
input x;
format x 8.;
cards;
1
2
3
4
;
run;
proc export data=q
outfile='c:\q.jmp'
DBMS=JMP replace;
run;
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 Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||