Like to program in SAS® analytics? Then you'll love programming SAS® analytics in JMP®.

I was visiting a customer recently – a large, successful pharmaceutical company that has used SAS and JMP for many, many years. However, they were using the products separately. The marketing group told me they need to deliver monthly market performance reports to senior management. To do so, they were pulling SAS data into custom spreadsheets to filter the data and provide graphical views of the data.

When I showed them JMP 7’s integration with the SAS platform, the room went silent. You could see the wheels spinning as the programmers quickly realized that they could do more for their management in significantly less time. They saw motion-enabled, interactive graphs to tell the month’s marketing story. They also saw a data filter that could be easily used by their senior manager to ask “what if” questions from the data. And they also saw a week’s worth of work whittled down to a couple of hours, with the potential for much deeper understanding of the data by senior management.

How did this happen?

JMP is a SAS product that has always delivered an interactive user experience that maintains intimacy with a user’s data. JMP 7 adds integration with the SAS®9 Platform, bringing dynamic data visualization to the SAS user. This is important to the SAS programmer because leveraging the powerful JMP environment, with SAS code, results in SAS applications that deliver rich graphics and data exploration.

SAS programmers want a development environment that includes graphical analysis and tools for their SAS data. Scientists and engineers who need SAS for data integration and advanced analytics will also greatly benefit from the new product integration. These people use JMP to access SAS data marts that contain their pre-integrated data. SAS applications built in JMP can provide these users point-and-click interfaces to advanced analytics available in other SAS products, such as SAS/STAT®, SAS/IML®, SAS/ETS® and SAS/QC®.

What are the integration points?

JMP 7 has the ability to run SAS Stored Processes authored by SAS Enterprise Guide® or other means. An intuitive user interface is included with dialogs generated from SAS Stored Processes. If JMP Scripting Language (JSL) is included with the SAS Stored Process, additional JMP features like interactive graphics can be surfaced to the users. Full JSL programming support is offered for SAS Stored Processes, including the ability to create custom dialogs in JMP to support SAS Stored Processes that need cascading prompts, selection boxes populated from SAS data sets, etc. JMP can access data that is defined physically on a SAS server using mechanisms like libnames run within a SAS program, an autoexec. Data defined in metadata can also be accessed with added authorization model provided by the SAS Enterprise Intelligence Platform. Users can “browse” data on the server, preview a fixed number of rows, choose columns, generate SQL or write custom SQL with an intuitive point-andclick interface. Users can write any SAS code within JMP and submit to a local SAS session using COM or run the SAS code on any SAS server defined in metadata or physical server running an object spawner. A new editor in JMP recognizes JSL and SAS code, and it presents a SAS log and SAS output window. JMP 7 also features the ability to incorporate any SAS code within JSL. This enables users to create “native” JMP interfaces that run SAS analytics in a point-and-click environment.

 

 

 

 

 

More on This Topic

Who should use JMP and SAS?

Integration Points

Key Features

Seamless Solutions

Download the Brochure
(PDF, 368KB, May 2007)

This story appeared in the sascom Magazine Special Supplement on JMP. Register to download a PDF of the entire 44-page supplement.