Rowsort installed but still not working

[Claire Essy]

Hi, I use Stata14. I installed rowsort (when I do again Stata says "all files already exist and are up to date"). Anyway, when I try to use, Stata says it is unrecognized.
For example, using sysuse auto, I typed:

rowsort make-headroom, gen (v1-v5) descend missing (-9)

and the output is:

command rowsort is unrecognized

[Nick Cox]

Specifically, sorting make-headroom makes no sense to me, as you're mixing up a string variable and various numeric variables. That could make sense given some rules, but rowsort doesn't support any combination of string and numeric.

Generically, please show us how to tried to install rowsort There is an older version at SSC and a newer version at the Stata Journal.

[Martyn Sherriff]

You cannot mix string and numeric values, from the help 'varlist should contain either only numeric variables or only string variables.'

# Crossed with Nick's response

[Claire Essy]

You are totally right, I did the example in a rush and did not check it was mixing numeric and string. Anyway, in my dataset I only want to sort numeric variables. I re-do an example with sysuse auto with all numeric variables and copy and paste since the installation of rowsort:

. ssc install rowsort
checking rowsort consistency and verifying not already installed...
all files already exist and are up to date.

. rowsort price-rep78, gen (v1-v3) descend missing(-9)
command rowsort is unrecognized r(199);


Hope this clarifies!

[Nick Cox]

Show us the result of

adopath 

[Claire Essy]

Sure:

. adopath
[1] "C:\Users\Claire\Folder1\prog"
[2] (BASE) "C:\Novell\Apps\Stata17MP2\ado\base/"
[3] (SITE) "C:\Novell\Apps\Stata17MP2\ado\site/"

I know it says Stata17 but I always set it as Stata14, because the code needs to be replicable on Stata14

[Nick Cox]

Any installation would be, or should be, into what sysdir calls PLUS. Essentially your adopath is set to look at your own commands and the official Stata installation, only.

How did that happen? You or someone else changed the default there.

Here's what mine looks like

.

 adopath
  [1]  (BASE)      "C:\Program Files\Stata17\ado\base/"
  [2]  (SITE)      "C:\Program Files\Stata17\ado\site/"
  [3]              "."
  [4]  (PERSONAL)  "C:\Users\Laptop\ado\personal/"
  [5]  (PLUS)      "C:\Users\Laptop\ado\plus/"
  [6]  (OLDPLACE)  "c:\ado/"

[Claire Essy]

I see, thank you very much. I think I did it somehow. I will try to fix it. If you have any idea, that is welcome, but I get that is outside the scope of the forum, so thanks for helping me understanding what was wrong!

[William Lisowski]

Note that you can find out what the missing components of adopath should be on your system by using the sysdir command.

. sysdir list
   STATA:  /Applications/Stata/
    BASE:  /Applications/Stata/ado/base/
    SITE:  /Applications/Stata/ado/site/
    PLUS:  /Users/lisowskiw/Library/Application Support/Stata/ado/plus/
PERSONAL:  /Users/lisowskiw/Library/Application Support/Stata/ado/personal/
OLDPLACE:  ~/ado/

. adopath
  [1]  (BASE)      "/Applications/Stata/ado/base/"
  [2]  (SITE)      "/Applications/Stata/ado/site/"
  [3]              "."
  [4]  (PERSONAL)  "/Users/lisowskiw/Library/Application Support/Stata/ado/personal/"
  [5]  (PLUS)      "/Users/lisowskiw/Library/Application Support/Stata/ado/plus/"
  [6]  (OLDPLACE)  "~/ado/"

My understanding is changes to adopath made with the adopath command only effect the current session, so you are presumably changing it somewhere in your code, or perhaps in the profile.do that is run each time Stata is launched.

I'm guessing, since you seem to be preparing code for others to use, that you have deliberately limited adopath to exclude all commands that are not installed as part of Stata, so that you could be sure what you wrote would run on the users' systems, provided they were at Stata 14 or later. That of course is at variance with using a community contributed command like rowsort. Or, you need to find the ado abd help files installed by rowsort in your PLUS directory and copy them to your project directory.

[Claire Essy]

Thank you so much! Yes, I had just to modify my profile.do, now everything works