Problem Note 31399: JMP® files created by SAS/ACCESS® Interface to PC Files in the UNIX environment cannot be read into the SAS® System
 |  |  |  |
Under UNIX, you can use SAS/ACCESS Interface to PC Files along with the PC Files Server component (using the DBMS=PCFS option in the EXPORT procedure) to create a JMP file. However, you cannot read that JMP file back into SAS.
The following log shows that the file was created successfully with PROC EXPORT, but an error also occurs:
proc export dbms=pcfs outfile="c:\temp\jmp1.jmp"
data=sashelp.class;
server=d18060;
port=8621;
run;
NOTE: "c:\temp\jmp1.jmp" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds
proc import dbms=pcfs datafile="c:\temp\jmp1.jmp" out=a;
server=d18060;
port=8621;
run;
ERROR: The variable name is illegal for file WORK.A.DATA.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.08 seconds
cpu time 0.02 seconds
If you originally create the JMP file by another means, it can be read into SAS with no problem. For example, the following log shows how a JMP file that is created with SAS/ACCESS Interface to PC Files in the Windows environment can be read in via the same code that failed in the previous example:
proc export dbms=jmp outfile="c:\temp\jmp2.jmp" data=sashelp.class;
NOTE: "c:\temp\jmp2.jmp" was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
run;
Under UNIX, the JMP file can be read back in if you use SAS/ACCESS Interface to PC Files with the DBMS=XLS option, as shown in this example:
proc export dbms=xls outfile="/tmp/jmp3.jmp"
data=sashelp.class;
run;
NOTE: The export data set has 19 observations and 5 variables.
NOTE: "/tmp/jmp3.jmp.xls" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | 64-bit Enabled AIX | 9.2 TS2M0 | |
| 64-bit Enabled HP-UX | 9.2 TS2M0 | |||
| 64-bit Enabled Solaris | 9.2 TS2M0 | |||
| HP-UX IPF | 9.2 TS2M0 | |||
| Linux | 9.2 TS2M0 | |||
| Linux for x64 | 9.2 TS2M0 | |||
| Solaris for x64 | 9.2 TS2M0 | |||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2008-05-12 15:49:07 |
| Date Created: | 2008-03-06 10:51:47 |