cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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)