Ok, I thought this one was really interesting. Usually external resources are reliable when it comes to old gen mechanics. Bulbapedia is probably accurate 90% of the time, and the holy grail of old gen info UltimatePokemonCenter is accurate like 99% of the time. However, I noticed an inconsistency between how both of them said weather-inducing moves in Gen 2 work, and how they work on the Showdown simulator.
In Gen 2, every online resource I'm familiar with says that every weather-inducing move can be used while its respective weather condition is active, and it'll supposedly reset the amount of turns that the weather condition is on the field. This is 100% accurate in-game for Rain Dance and Sunny Day. You'd assume Sandstorm would work the same way.
From bulbapedia:
Sandstorm: When this move is used, a sandstorm will brew. This effect will last for 5 turns. This clears any other weather and is usable when the weather is sandstorm.
From UPC:
The weather moves (Sunny Day, Rain Dance, Sandstorm) can be used at any time, even during weather. A weather move, when used, resets the number of turns of the effect to 5 (including the current turn) and cancels any other weather effect. A weather move will succeed even if the weather condition associated with it is in effect.
Both these websites seem to think so. However, on the simulator, this happened.
https://replay.pokemonshowdown.com/gen2ou-739269140
You can see here that using Rain Dance and Sunny Day while the respective weather was already on the field worked just fine. The turns reset, nothing else happened. However, with Sandstorm, the move failed, and the turn counter didn't reset to 5. This intrigued me, so I had to load up the emulator and find out for myself who was correct.
Turns out Showdown had it right all along. Sandstorm will fail if it's used while a sandstorm is raging. Not sure what the code explanation for this little quirk is, but I figured I'd publicize it here since both the websites I usually consult had it wrong. Nice catch by the sim devs!