My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to ...

You should be able to do division with a count () result. Not sure what the exact limitations are in Access, but it definitely works in SQL Server.

As in other PROC and DATA steps, you can use only a view descriptor or other SAS data set in an SQL procedure statement, not an access descriptor. You can usually only browse data retrieved using a ...

Therefore, special consideration should be used when the names of DBMS objects, such as tables and columns, are used with SAS/ACCESS and the SQL Procedure Pass-Through Facility. See your DBMS chapter ...