nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Save JMP datatable directly to SAS Server

hellind

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?

Accepted answers

jschroedl

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

All comments

Jeff_Perkinson

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

[Missing image]

hellind

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

jschroedl

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

katherinetk

Solution :

Make sure the correct data table window is active. And On the File menu, click Save As Server Data Set.
IML Studio will display the Save As Server Data Set dialog box. In the control SAS Workspace Servers, navigate to the appropriate server and select the library in which you want to save the data set. In the Data set name box, type the name for the new data set. Click OK.