Yes, there is a product called SAS/ACCESS Interface to ODBC. You can check if you have it installed and licensed by running this: proc product_status; run; proc setinit; run; However SAS/ACCESS Interface to SQL Server should also work. Did the SQL Server LIBNAME assign without errors or not? Please post your SAS log. ... View more

The first thing to check are firewall rules for the port(s) the ODBC driver is using. Does your SAS server run on Linux or Windows? It's a lot easier to test this on Windows as you can do this all in the Windows ODBC Administrator tool. ... View more

We use ODBC with SQL Server a lot and find it works well. We don't use JDBC at all. In my experience the connection strings are a lot more straightforward. Feel free to try that again if you like.  ... View more

My best guess as to what's happening here is that for some reason your schema setting isn't working and that you are ending up in a default schema with no tables. I'd suggest opening a track with Tech Support to make further progress. Is JDBC the only SAS/ACCESS product you have? Is SAS/ACCESS to ODBC or SAS/ACCESS to SQL Server an option you can try?  ... View more

What does PROC DATASETS report? proc datasets library = PATHNCPP; contents; run; quit; ... View more

Dataset file size is governed by the number of data pages and their size like so: In the above there is one data set page and one data page for a total of two, hence the file size of 128K. Please post the same from your PROC CONTENTS. ... View more

You will find answers to most of your questions in the SAS docs: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p16esisc4nrd5sn1ps5l6u8f79k6.htm ... View more

Does the chosen database and schema genuinely have tables in it? If so how long are the tables names? If they are all > 32 characters then SAS can't handle this and will not return any names. Try creating a table <= 32 characters long and see if that works. Open the LIBREF pathncpp in SAS EG or SAS Studio to see if any tables are listed. ... View more

@bitcruncher - Wow catalogs on zOS! Pretty amazing you can still read these after all that time! ... View more

I've never used APM but it is interesting to note that you are getting > 86% compression on the ARTIFACTUSAGEDETAILS dataset. That suggests it contains a lot of empty space. To reduce it in size one obvious thought would be to reduce the history kept. You will need to analyse the dataset in more detail to understand why it has grown so much. Comparing it to an earlier and smaller version would be useful.   ... View more

In my experience cloud latency will depend a lot on the type of network connection you have between on-prem and cloud. Ideally a dedicated cloud private link should provide good performance. We are using such a connection between SAS and Snowflake and performance is very good.   With on-prem to on-prem dedicated fibre connections should be available and latency should not be an issue.       ... View more

I suggest you check your server disks IO performance with the SAS IO Test Utility before doing anything. ... View more

You can't leverage your local computer's performance advantage unless you switch some of your SAS processing to it. You could parallel process some steps using both your PC and your remote server at the same time.   Have you discussed the SAS server performance with your SAS administrator? In my experience if your PC outperforms your remote SAS server then there is something seriously wrong with the server resources available to you. You might also want to consider doing remote server processing after hours if it performs much better then.   ... View more