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.)?
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?
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
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:
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.
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.
There are no labels assigned to this post.