BUG: No error raised in to_stata() for -np.inf #45350
* Add an absolute function when checking infinity, which includes both np.inf and -np.inf. Also changed the error message a bit.
* Add similar tests but replacing np.inf with -np.inf and change the correct error message accordingly

- [ ] closes #45350
- [ ] tests added / passed
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit) for how to run them
- [ ] whatsnew entry

thanks @flcong 