topic Printing List of Columns (variables?) in Discussions

Printing List of Columns (variables?)

Anonymous — Tue, 19 Jan 2016 14:44:44 GMT

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!

Re: Printing List of Columns (variables?)

txnelson — Tue, 19 Jan 2016 18:29:46 GMT

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 )

);

Re: Printing List of Columns (variables?)

ms — Tue, 19 Jan 2016 18:57:04 GMT

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)