[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
RE: st: outsheeting highest frequency values
I recommend against labelling any questions "quick".
It is at best superfluous and at worst irritating.
On the answers:
-tabsort- lost some, but not all, of its usefulness
when -tabulate- acquired a -sort- option to do
some of what -tabsort- can do.
In addition to other solutions, check out -groups-
> You could use Nick Cox' -tabsort- command, then select the
> part of the
> ordered table that you want from the Results window, do a Copy Table
> (Shift-Ctrl-C) from the Edit menu, and paste into Excel.
> There will be a
> bit of column deletion to do in Excel, getting rid of the unwanted (I
> presume) percents and cumulative percents.
> This is a variable by variable solution. You could automate
> the first part
> (the sort-by-frequency tabulations) by using a -foreach- loop
> on -tabsort-,
> but the copying and pasting is still manual. With only 20
> variables this
> might be manageable.
> There would be cleverer, more automated, solutions involving a bit of
> programming and output into a matrix, I expect.
> >I have a quick question: there are 20 variables, and I want to tab
> >each variable's values in frequency from high to low, and exporting
> >each variable's first 10 highest frequency values into a spreadsheet.
> >What commands am I supposed to use?
* For searches and help try: