Sample 44245: Use JMP® software to run a SAS program that manipulates a JMP data table
 |  |  |  |  |  |
Overview
This sample demonstrates how you can run a SAS program from within JMP to manipulate a JMP data table. This capability benefits JMP users who program in SAS and who might have only remote access to a SAS server.
Prerequisites
You need to have the following set up in order for this sample to work:
- A SAS server connection. For instructions in JMP 9.0.2, refer to the "Working with SAS" section that begins on page 363 of Using JMP. This documentation is located at http://jmp.com/support/downloads/pdf/jmp902/using_jmp.pdf. It is also available within JMP, by selecting Help ► Books ► Using JMP.
- SAS/ACCESS Interface to PC Files. SAS needs this to access JMP files.
- The SAS server must have access to the JMP files that you use. This sample uses the Big Class table that is located in the Sample Data folder of the JMP installation directory.
- If you work with JMP 9 tables, then you must use SAS 9.3 or later.
Instructions
In a JMP session, select File ► SAS ► New SAS Program. Copy-and-paste the following SAS code into the SAS Program Editor - JMP window:
This SAS program creates a subset of the Big Class JMP table by importing it into a SAS data set via the IMPORT procedure and subsetting the data via a DATA step. The resulting BigClass10 data set is printed to an output window and can be opened in JMP.proc import datafile='<path-to-JMP-sample-data>\Big Class.jmp' out=work.bigclass dbms=jmp replace; run; data work.bigclass10; set work.bigclass; /* create a subset that has the first 10 observations of BIGCLASS */ if _n_ le 10; run; proc print data=work.bigclass10; run;
Before you execute this SAS program, update the path in the DATAFILE= as needed for your installation. To execute the SAS program, right-click inside of the SAS Program Editor - JMP window and select Submit to SAS.
When JMP prompts you with the Connect to SAS Server window, select and enter the SAS server information that is appropriate for your setup:
Click OK. Output like the following should then appear in a SAS Output window:
You can view the SAS log by selecting File ► SAS ► Open SAS Log Window.---------------------------------------------------------------------------------------------------- The SAS System 15:43 Friday, September 9, 2011 1 Obs name age sex height weight 1 KATIE 12 F 59 95 2 LOUISE 12 F 61 123 3 JANE 12 F 55 74 4 JACLYN 12 F 66 145 5 LILLIE 12 F 52 64 6 TIM 12 M 60 84 7 JAMES 12 M 61 128 8 ROBERT 12 M 51 79 9 BARBARA 13 F 60 112 10 ALICE 13 F 61 107 ====================================================================================================
Additional Documentation
For more information about executing SAS code from within JMP, see the "Submitting SAS Code" section of Using JMP. For JMP 9.0.2, this documentation begins on page 373 and is located at http://jmp.com/support/downloads/pdf/jmp902/using_jmp.pdf. It is also available within JMP, by selecting Help ► Books ► Using JMP.
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
proc import
datafile='<path-to-JMP-sample-data>\Big Class.jmp'
out=work.bigclass
dbms=jmp
replace;
run;
data work.bigclass10;
set work.bigclass;
/* create a subset that has the first 10 observations of BIGCLASS */
if _n_ le 10;
run;
proc print data=work.bigclass10;
run;
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
----------------------------------------------------------------------------------------------------
The SAS System 15:43 Friday, September 9, 2011 1
Obs name age sex height weight
1 KATIE 12 F 59 95
2 LOUISE 12 F 61 123
3 JANE 12 F 55 74
4 JACLYN 12 F 66 145
5 LILLIE 12 F 52 64
6 TIM 12 M 60 84
7 JAMES 12 M 61 128
8 ROBERT 12 M 51 79
9 BARBARA 13 F 60 112
10 ALICE 13 F 61 107
====================================================================================================
With SAS® Visual Data Discovery, you can execute a SAS program from within JMP. This sample demonstrates how you can manipulate a JMP table by running a SAS program within JMP.
| Type: | Sample |
| Topic: | Analytics ==> analytics Common Programming Tasks ==> Conditional Processing Common Programming Tasks ==> Reading and Writing External Data ==> with PROC IMPORT Common Programming Tasks ==> Reading and Writing SAS Data Data Management ==> Access ==> Client/Server Data Management ==> Access ==> Import Data Management ==> Data Sources ==> External Databases Data Management ==> Data Sources ==> Metadata Data Management ==> Data Sources ==> SAS Data Sets/Tables Query and Reporting ==> Creating Reports ==> Non Graphical SAS Reference ==> DATA Step SAS Reference ==> Procedures ==> IMPORT SAS Reference ==> Procedures ==> PRINT Third Party |
| Date Modified: | 2011-09-27 15:10:47 |
| Date Created: | 2011-09-09 09:06:39 |
Operating System and Release Information
| Product Family | Product | Host | Product Release | SAS Release | ||
| Starting | Ending | Starting | Ending | |||
| JMP Software | SAS Visual Data Discovery | Microsoft® Windows® for 64-Bit Itanium-based Systems | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | ||||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | ||||||
| Microsoft Windows XP 64-bit Edition | ||||||
| Microsoft® Windows® for x64 | ||||||
| Microsoft Windows 95/98 | ||||||
| Microsoft Windows 2000 Advanced Server | ||||||
| Microsoft Windows 2000 Datacenter Server | ||||||
| Microsoft Windows 2000 Server | ||||||
| Microsoft Windows 2000 Professional | ||||||
| Microsoft Windows NT Workstation | ||||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||||
| Microsoft Windows Server 2003 Standard Edition | ||||||
| Microsoft Windows Server 2003 for x64 | ||||||
| Microsoft Windows Server 2008 | ||||||
| Microsoft Windows Server 2008 for x64 | ||||||
| Microsoft Windows XP Professional | ||||||
| Windows 7 Enterprise 32 bit | ||||||
| Windows 7 Enterprise x64 | ||||||
| Windows 7 Home Premium 32 bit | ||||||
| Windows 7 Home Premium x64 | ||||||
| Windows 7 Professional 32 bit | ||||||
| Windows 7 Professional x64 | ||||||
| Windows 7 Ultimate 32 bit | ||||||
| Windows 7 Ultimate x64 | ||||||
| Windows Millennium Edition (Me) | ||||||
| Windows Vista | ||||||
| Windows Vista for x64 | ||||||
| JMP Software | JMP software | Macintosh | 8.0 | |||
| Microsoft® Windows® for x64 | 8.0 | |||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 8.0 | |||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 8.0 | |||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 8.0 | |||||
| Microsoft Windows XP 64-bit Edition | 8.0 | |||||
| Microsoft Windows 95/98 | 8.0 | |||||
| Microsoft Windows 2000 Advanced Server | 8.0 | |||||
| Microsoft Windows 2000 Datacenter Server | 8.0 | |||||
| Microsoft Windows 2000 Server | 8.0 | |||||
| Microsoft Windows 2000 Professional | 8.0 | |||||
| Microsoft Windows NT Workstation | 8.0 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 8.0 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 8.0 | |||||
| Microsoft Windows Server 2003 Standard Edition | 8.0 | |||||
| Microsoft Windows Server 2003 for x64 | 8.0 | |||||
| Microsoft Windows Server 2008 | 8.0 | |||||
| Microsoft Windows Server 2008 for x64 | 8.0 | |||||
| Microsoft Windows XP Professional | 8.0 | |||||
| Windows 7 Enterprise 32 bit | 8.0 | |||||
| Windows 7 Enterprise x64 | 8.0 | |||||
| Windows 7 Home Premium 32 bit | 8.0 | |||||
| Windows 7 Home Premium x64 | 8.0 | |||||
| Windows 7 Professional 32 bit | 8.0 | |||||
| Windows 7 Professional x64 | 8.0 | |||||
| Windows 7 Ultimate 32 bit | 8.0 | |||||
| Windows 7 Ultimate x64 | 8.0 | |||||
| Windows Millennium Edition (Me) | 8.0 | |||||
| Windows Vista | 8.0 | |||||
| Windows Vista for x64 | 8.0 | |||||
| Linux | 8.0 | |||||
| Linux for x64 | 8.0 | |||||
| Linux on Itanium | 8.0 | |||||
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows XP 64-bit Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 9.21 | 9.2 TS2M3 | ||||
| Microsoft Windows XP Professional | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 9.21 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 9.21 | 9.2 TS2M3 | ||||
| Windows Vista | 9.21 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 9.21 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 9.21 | 9.2 TS2M3 | ||||
| 64-bit Enabled HP-UX | 9.21 | 9.2 TS2M3 | ||||
| 64-bit Enabled Solaris | 9.21 | 9.2 TS2M3 | ||||
| HP-UX IPF | 9.21 | 9.2 TS2M3 | ||||
| Linux | 9.21 | 9.2 TS2M3 | ||||
| Linux for x64 | 9.21 | 9.2 TS2M3 | ||||
| OpenVMS on HP Integrity | 9.21 | 9.2 TS2M3 | ||||
| Solaris for x64 | 9.21 | 9.2 TS2M3 | ||||