03-23-2012 12:46 PM
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.
03-23-2012 01:35 PM
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.
03-23-2012 09:22 PM
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.