cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Registration open for Discovery Summit Europe. User Group Members benefit from a 25% discount with the code: DSEUgroup24
Choose Language Hide Translation Bar
Oren_Bar-Ilan
Level III

How to get table information

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

7 REPLIES 7
tom_abramov
Level V

Re: How to get table information

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.

Oren_Bar-Ilan
Level III

Re: How to get table information

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

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

Avigdor
Visitor

Re: How to get table information

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.
Jeff_Perkinson
Community Manager Community Manager

Re: How to get table information

Check out the Table Attributes Add-In by @Justin_Chilton

 

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

-Jeff
Oren_Bar-Ilan
Level III

Re: How to get table information

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

Oren_Bar-Ilan
Level III

Re: How to get table information

Thank you all for providing possible solutions to my request.

 

Oren.