How to get table information

[#1]

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

[#2]

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.

[#3]

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 

[#4]

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

[#5]

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.

[#6]

Check out the Table Attributes Add-In by @Justin_Chilton. 

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

[#7]

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

[#8]

Thank you all for providing possible solutions to my request.

Oren.