cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Printing List of Columns (variables?)

Just checking to see if this is available...Is there a way to print out the entire list of columns/variables in a study (with short and long names) for reference?  With a very large database, it can sometimes be difficult to navigate through the list and could be handy to have an entire printout if available.  Thanks!

2 REPLIES 2
txnelson
Super User

Re: Printing List of Columns (variables?)

Here is a simple script that will copy all of your column names into a column, which you can then do anything you want.

Names Default To Here( 1 );

dt = Current Data Table();

newdt = New Table( "columns",

   New Column( "Column Names",

   character,

   values( dt << get column names ) 

);

Jim
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Printing List of Columns (variables?)

A quick way to get all column names to the clipboard: Click in the columns field in the tables left panels, type cmd-A and cmd-C (ctrl-A and ctrl-C in Windows).

Paste the list into your favorite editor and print.

(The columns panel is even more useful for changing multiple column names by simply pasting them from another application)