topic SAS toolbox in SAS Procedures

SAS toolbox

michtka — Fri, 23 Mar 2012 16:46:58 GMT

I guys,

I am relly enjoying with SAS: toolbox using vt (viewtable) or fsv (fsview), because is very handy to QC_listings.

Please, Can anyone tell me if there exist some option to re-order the variables

in the dataset, similar to the function retain in the sas code.

i put retain in the command bar of the sas toolbox and it doesnt work.

I know there is a function move using fsview but is a bit slow, and i dont like

very much, i would like to find something more quick.

Cheers,

Mictka.

SAS toolbox

ballardw — Fri, 23 Mar 2012 17:35:37 GMT

if you issue the VT command with the option OPENMODE=EDIT then when the table is open you can select variables to sort by clicking in the column heading. Sort using the a-z z-a buttons on the toolbar. Hold down the ctrl key to select multiple variables (at least in Windows). This does sort by the order variables are selected when multiples are sorted.

SAS toolbox

michtka — Sat, 24 Mar 2012 01:22:29 GMT

Sorry ballard, i am not talking about sorting the variables, maybe I confused you.

sorting variables with SAS toolbox is great in the VT tables.

I am talkin abour retain the order of the variables:

sometime the dataset (old) become a d b c f t e g

and would like a (new) as: a b c d e f g.

I can do it using retain in a new datset: data new; retain a b c d e f; set old; run;

or using proc sql

and this is my question...we can order the columns in the sequence that i want?

Thanks for your reply anyway.

SAS toolbox

michtka — Sat, 24 Mar 2012 03:03:09 GMT

I found it, in the help.

Hide/Unhide option.

Or click the column in the viewtable and drag to the position you want.