topic Re: How to get table information in Israel JMP Users - קבוצת משתמשים - ישראל

How to get table information

Oren_Bar-Ilan — Sun, 08 Dec 2019 13:39:14 GMT

Hello,

Is there a way in JMP to obtain the information on a table , similar to what SAS PROC CONTENTS does (names of columns, number of rows, columns names, columns types, etc.)?

Thanks, Oren

Re: How to get table information

tom_abramov — Tue, 10 Dec 2019 13:46:03 GMT

Hi Oren,

I am not familiar with SAS PROC CONTENTS,

but I know that in JSL you can get all the information you need with separate commands. Here are some:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Get Script();
dt << Get Column Names("string");
Nr = NRows(dt);
Nd = NCols(dt);
dt:Age << Get Data Type;
dt:Age << Get Modeling Type;

Is this enough for you?

BR,

Tom.

Re: How to get table information

Oren_Bar-Ilan — Mon, 09 Dec 2019 09:11:12 GMT

Hi Tom,

Thank you for the quick reply. I tried running the script you sent but couldn't find the output.

Anyway, I would need a more elaborated output that contains all table's information like the CONTENTS produces. This is for regulatory purposes and the expectation is to have an output similar to what SAS does.

I would probably have to look for other solutions.

Thanks again, Oren

Re: How to get table information

MassimoMartucci — Tue, 10 Dec 2019 08:17:14 GMT

Hi Oren,

sadly there is no such out-of-the-box procedure in JMP for this use of PROC CONTENTS.

The closest feature in JMP is the Column Viewer platform, from main menu -> Cols -> Column Viewer:

https://www.jmp.com/support/help/en/15.0/#page/jmp/select-columns-in-the-columns-viewer.shtml

By using JSL DataTable functions, you have more low-level functions to get details about tables and files in general, but this implies the writing of JSL code.

I suggest you to try the Column Viewer and eventually to report your question to the main WW JMP Community, so that you have greater visibility.

Hope this helps.

Bye, Massimo

Re: How to get table information

Avigdor — Tue, 10 Dec 2019 10:55:55 GMT

The *Column Viewer* option is quite useful, especially the feature of *Data
Table View* of the information presented when asking for *Show Summary*, as
it presents all column names (in the data table) in a table column,
allowing printing, sorting&printing, etc.
However, *that Summary table could be more useful it it would be connected
to the data table*, in a way that changes in titles in the *Columns* column
would change titles in the data table. For example, if many columns in the
data table contain the word "Mean" (e.g. because they were generated by
*Summary*), I can remove at once all these "Mean"s (if I want to shorten
the titles) by using "Find" and replacing all of them with a blank.

Re: How to get table information

Jeff_Perkinson — Tue, 10 Dec 2019 13:49:09 GMT

Check out the by @Justin_Chilton.

I think it might be what you're looking for.

Re: How to get table information

Oren_Bar-Ilan — Tue, 10 Dec 2019 17:30:46 GMT

Hi Jeff,

Thank you very much. I've just downloaded the add-in you recommended. It does not provide information on the table itslef (table name, date of creation, etc.) but this is probably the colsest solution to what I'm looking for.

BR, Oren

Re: How to get table information

Oren_Bar-Ilan — Tue, 10 Dec 2019 17:34:55 GMT

Thank you all for providing possible solutions to my request.

Oren.