Just as an FYI, Enterprise Guide is a .NET software which does not use JDBC protocol. EG uses connection profile, which stores information such as - Connection name: - Connection Description: - Metadata Server name - Port : 8591 (Default) - UserName: - UserPW:   Your username  has to be registered in the SAS Metadata base in order to authenticate you first, before it can figure out your authorization settings. So if you don't have to SAS Enterprise Guide, contact your "SAS experts"/SAS Admin and verify you are registered and authorized to access the SAS deployment  ... View more

@andre_young  I personally try to verify connection using multiple software packages where possible. I would recommend finding another JDBC supporting software be it free, such as DBeaver Community Edition,  or commercial, whichever you can get access to, to try connecting to SAS via JDBC.   In the past, I have discovered different packages have different level of support to standard protocols such JDBC/ODBC. Even Driver providers, have different level of supporting/implementing Driver Specifications.   Just a thought  ... View more

@andre_young    Have a look into this guide for connection examples  SAS 9.4 Drivers for JDBC: Cookbook   Look on page 26 (32/58), at the bottom, there is JDBC URL connection example   Hope it helps ... View more

Hi @Ronein  One technique I've been using to reduce my SAS data set size, is setting my Integer numeric variable to length of 3 instead of the default 8! Where these integer values are typically used to store Boolean flags (0/1, True/False) for modeling purposes. But if you intent to use these integers for aggregations, then keeping them with the default length of 8, would preserve their precision.   Check this SAS on-line help SAS Help Center: Numeric Precision for more details.   Hope this helps ... View more

@RexDeus9  Can you please clarify what do you mean by multiple servers? Is it Multiple tiers (Meta, Compute, Web) OR Multiple instances of each tier (Meta, MetaN, Comp1, Comp2, CompN, Web, WebN)  @GerryNelson  any insight/tips you can share here? ... View more

Hi @RexDeus9  Have a look at this blog https://blogs.sas.com/content/sgf/2021/07/23/how-to-use-the-sas-9-content-assessment-tool/?msclkid=bfef1e72c7e711ec90c9d3ffa50f819e   And this Tech Support doc: https://support.sas.com/content/dam/SAS/support/en/technical-papers/sas-content-assessment-proven-practice.pdf   Hope this helps ... View more

Hi @Kastchei  Regardless of the size of your data set, most of the information provided by Proc Contents are already stored in the SAS supplied data dictionary tables/view!   Proc contents displays the metadata (data dictionary) of a SAS dataset, including variable names, types, lengths, and attributes like labels and formats. It is also used to view the structure of a library or a specific table, showing information such as the number of observations, variables, and when the dataset was created. This makes it a valuable tool for understanding a dataset, verifying that data was imported correctly, and performing more intelligent data processing.   Guess what, as soon as you assign a libname that contains your SAS data set(s), SAS behind the scenes gathers all the metadata about your SAS data sets. Check this paper Exploring DICTIONARY Tables and Views for more details.   Note: Running proc contents does not require splitting your data set, regardless of how big it is.   Hope this helps ... View more

Hi @PhilGUK  Considering what you have mentioned "We are SAS Studio Version: Stable 2025.09", it sounds like you are running/using SAS Viya!! While Lift (v9 code) and Shift (run on Viya compute) is possible, it does not always give you all the performance enhancements that comes with Viya!! If you have the option/ability to convert your existing/current SAS V9 code to utilize CAS and CASL, you may find yourself not needing explicit Parallel code execution, because CAS and CASL does that implicitly behind the scenes for you and cuts down the 50 min processing to much lower.       Just a thought, hope it gives you another perspective    ... View more

Hi @sascis  Do you know exactly which SAS solution bundle your organization have deployed? If your SAS Deployment happens to have SAS OLAP server part of the bundle, then you would be able to build a SAS OLAP Cube and open it from within Excel Pivot Table.   Alternatively - Check this video https://video.sas.com/detail/videos/version-8/video/5978114907001/version-8:-interacting-with-sas-data-in-a-microsoft-excel-pivottable-with-the-sas-add-in-for-microsoft-office?autoStart=true Create and Save Excel Workbooks that connects to SAS Server and exposes the SAS data set(s) in Pivot tables Allow Read-only access to your users, where they would be able to interact and Slice & Dice the data via the Pivot table interface, but not saving their changes/edits. They would be able to export/save-as into a another/personal copy as and when needed! Hope this gives you a useable work-around Ahmed     ... View more

Does this paper More Than Just a Pretty Face: Using the SAS® Output Delivery System to Create Microsoft Excel Worksheets That Answer Those Difficult Questions answer your question. Check page 11, it has an example using Data Range from a different sheet   Hope this helps ... View more

@NicolasRobert  Have you tried to use GitHub integrated VS Code from within the Browser? To open a GitHub repository directly in VS Code for the Web, simply use URL shortcuts by changing the domain in the repository’s link. GitHub.dev Shortcut In your browser, replace  github.com  with  github.dev  in the URL of the repository. For example, change: https://github.com/owner/repository to: https://github.dev/owner/repository This URL will instantly open the repository in Visual Studio Code for the Web, showing all files and folders in the VS Code interface.​ Vscode.dev Shortcut You can also use the VS Code web editor's direct URL: https://vscode.dev/github/owner/repository This works the same way, letting you quickly browse and edit content without downloading anything. ... View more

@EmmettSmith24  @samiulhaque  I wish SAS V9 R&D team and Product management pay attention to your finding and understand the High Cost constraints/ownership of SAS V9 in the cloud the current SAS users are complaining about!! IF they could provide/port-back the ability to read/write and process Parquet files like they have done with SAS Viya, running SAS V9 efficiently in the cloud wouldn't be a cost prohibitive as it is today!    ... View more

@LukeW21  Here is an additional resource to look into SAS® 9.4 Stored Processes: Developer’s Guide, Third Edition  Try to access the SAS Stored Process Web Application http://yourserver.com:8080/SASStoredProcess/do , within this web app, there are a list of Stored Process Samples, one of these samples, illustrates how to use multiple output formats "Sample: Multiple Output Formats - Using ODS to generate PDF, PostScript, RTF and other output"  You can use this sample as a guide.   Hope this helps   ... View more

@Markus04  Are you sure? According to the on-line docs https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0sc92audsisvsn1jbd0fx3nealw.htm SAS/ACCESS Interface to Postgres supports bulk loading! ... View more

Hi @eramirez  Have a look at these three papers REST at Ease with SAS®: How to Use SAS to Get Your REST The ABCs of PROC HTTP REST Just Got Easy with SAS® and PROC HTTP They should have what you are looking for and more ... View more