Subscribe Bookmark RSS Feed

Save JMP datatable directly to SAS Server

hellind

Community Trekker

Joined:

Jun 23, 2011

I have a datatable opened in JMP.

How do I save this datatable as SAS dataset into a sas workspace? I am connected to the SAS Workspace, I can Browse SAS Data.

I am able to save the datatable as SAS dataset into my local folder, and then use EG to open the dataset.

But I thought there would be a direct way to write to the SAS Server from JMP?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

The Export Data to SAS UI is only in JMP 9 but if you're willing to run a simple script you can easily do this in JMP 8.

ex: I just ran this fine in JMP 8

sas = SAS Connect("sasmain");
sas << Export Data(Current Data Table(), "work.test");


or if you've already connected to SAS and just want to use the current connection it's even easier:

SAS Export Data(Current Data Table(), "work.test");

  John

3 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

In JMP 9 you'll find File->SAS->Export Data to SAS...

[Missing image]

-Jeff
hellind

Community Trekker

Joined:

Jun 23, 2011

Export Data to SAS option is only available in Jmp 9+.

Solution

The Export Data to SAS UI is only in JMP 9 but if you're willing to run a simple script you can easily do this in JMP 8.

ex: I just ran this fine in JMP 8

sas = SAS Connect("sasmain");
sas << Export Data(Current Data Table(), "work.test");


or if you've already connected to SAS and just want to use the current connection it's even easier:

SAS Export Data(Current Data Table(), "work.test");

  John