Maybe this article could be of your interest:
36112 - Managing large SAS® data sets that exceed the maximum number of observations
I don't know if your users are making use of Enterprise Guide or SAS Base. My first guess would go to the first option.
In Enterprise Guide (I am not sure in 9.2 right now) in Tool-Options-Data-Performance, you should be able to set the number of rows to display.
In any code, you can also make use of the OBS paramenter: SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition and
Use the OBS and FIRSTOBS Options to Save Time While Testing - sasCommunity
If there is any specific for SQL Server, sorry, I don;t know. But if any, you should be able to include in the library definition with: library-properties-Options-Advanced Options- Other options.