You confuse not well comparable quantities.
In any radio system, you need to get an usable power from a transmitter to a receiver, by using suitable antennas.
To transmit information, the signal must be modulated by e.g. data. The modulation generates a signal spectrum which requires a certain bandwidth to be transmitted from transmitter to receiver. The bandwidth in receiver is limited to such required width by filters, and it establishes the noise power above which signal power must be,The ratio of both powers, S/N, defines receiver and system quality to transmit information.
The data rate is a secondary modulation parameter. BY signal processing in a receiver, bit error rate varies with the S/N ratio , and both should be designed to certain minimum value to get a good transmission quality.
For various types of modulation and demodulation, methods were developed to improve BER over S/N, like forward error correction, adaptive filtering, etc. Such methods often take a part of data rate to function, so a careful analysis of a system is needed to understand and optimize it.
The distance between the transmit and receive antennas, plus propagation effects, affect the S/N ratio, and should be used in the primary system design steps.
I would suggest you to read a good textbook on radio and digital communication basics. Your question is generally difficult to answer in short, and many variations exist.