A paper that I've read talks about using mixed=yes with the Excel libname engine. It then talks about setting the MS Jet TypeGuessRows key in the Windows registry to 0 so that the whole column will be looked at to determine the field type (as opposed to the first 8 rows.)

So, as I don't want to be running around checking (and re-checking) everyone's Windows registry, is there a way to (safely) change this key in SAS code?

Thanks