SASKiwi Tracker

Re: How to periodically clear the log ONLY IF none error?!

SASKiwi — Mon, 07 Sep 2026 02:04:40 GMT

If I'm dealing with large logs, I run such jobs in batch mode, then log size doesn't matter hence no log clearing is necessary. That also frees up your user interface of choice to just concentrate on development work.

Re: SAS 9.4M7 ODS PRINTER PDF: Large Blank Space Before Continuation Text When a PROC REPORT Cell Sp

SASKiwi — Thu, 03 Sep 2026 00:42:00 GMT

I ran your test program on M8 and got identical results to you.

I'd suggest opening a Tech Support track as they are more likely to know about maintenance level differences and any fixes.

Re: Using PROC COMPARE with Case Insensitivity

SASKiwi — Wed, 02 Sep 2026 20:13:33 GMT

IMHO PROC COMPARE is such a useful tool and is one of my most frequently used ones. It's invaluable for developers to check the impact of process changes, but also for administrators to confirm if data is identical across SAS environments.

It could definitely do with a bit of love though, as its reporting capabilities still seem to be stuck in pre-ODS days.

Re: SAS 9.4M7 ODS PRINTER PDF: Large Blank Space Before Continuation Text When a PROC REPORT Cell Sp

SASKiwi — Wed, 02 Sep 2026 02:58:50 GMT

Can you post a test program that reproduces the problem plus a screenshot of the PDF produced? We can run it in a later maintenance release to see if it behaves the same.

Re: An unexpected error when starting SAS Viya Studio

SASKiwi — Sun, 30 Aug 2026 20:09:26 GMT

The usual place to start when investigating problems of this type is server logs. Since you have already worked with your platform administrator I'm guessing that's already happened. Opening a track with Tech Support is the next best option since more troubleshooting will be needed.

Re: Enterprise Guide: Add option for an audible tone when SAS Program/Project Completes

SASKiwi — Sun, 23 Aug 2026 21:34:06 GMT

Very cunning!

Re: Enterprise Guide: Add option for an audible tone when SAS Program/Project Completes

SASKiwi — Fri, 21 Aug 2026 00:33:08 GMT

If EG is running local SAS on your PC then there is already the CALL SOUND routine which you can try. You can even play a tune if you so wish 😊

Of course this isn't an option if EG uses remote SAS servers.

Re: Create snowflake table as select from sql

SASKiwi — Thu, 13 Aug 2026 20:43:09 GMT

I'm wondering if there's some unprintable characters in the load data upsetting the layout of bulk load file. Maybe try bulk loading a small sample first.

Re: Create snowflake table as select from sql

SASKiwi — Thu, 13 Aug 2026 20:04:53 GMT

What happens if you don't use the BULKLOAD option? Still the same errors? Also what version and maintenance level of SAS is this?

Re: SAS email won't attach PowerPoint slide

SASKiwi — Thu, 13 Aug 2026 00:31:53 GMT

This worked fine for me. I created a test PPTX in Powerpoint, saved it to a SAS server folder, ran the below program. I just double-clicked on the email attachment and the Powerpoint opened as I expected:

filename mymail email "My.Name@MyOrg.com"
         subject="PPTX Test"
         attach=("TestPPTX.pptx"  content_type="application/pptx" 
         );

data _null_;
   file mymail;
   put 'Hi Me,';
   put 'This is a test.';
run;

This is the test email:

SASKiwi_0-1786581079707.png

Re: SAS email won't attach PowerPoint slide

SASKiwi — Wed, 12 Aug 2026 20:07:06 GMT

The usual way to add an email attachment that is for a specific application is to use the CONTENT_TYPE option. Try something like this:

filename mymail email "My.Name@MyWork.com"
         subject="PPT Test"
         attach=("MyPPT.pptx"  content_type="application/pptx");

data _null_;
   file mymail;
   put 'Hi Me,';
   put 'This is a test.';
run;

Re: SAS 9.4 M7 with Java 21 – Alternative Integration Options

SASKiwi — Tue, 11 Aug 2026 21:13:27 GMT

It depends on what your Java frontend application is doing and where it is installed. If it is only, for example, installed on PCs and is running SAS jobs in batch (sas -sysin "MySASPgm.sas") on remote SAS servers then retrieving Excel and HTML file from the batch jobs, what Java version you use doesn't matter. All SAS sees are the batch program calls.

Where the Java version does matter is if it is part of the software stack installed on the SAS servers themselves.

Re: SAS deletes the trailing blanks '20'x from the binary key

SASKiwi — Fri, 07 Aug 2026 03:52:57 GMT

If you use SAS/ACCESS Interface to SAP HANA then this is the default data type in SAS for VARBINARY:

SASKiwi_0-1786074367691.png

if you haven't done so already then I'd suggest confirming that SAS is actually reading the binary key OK by comparing a few hex values in SAS with those in SAP. If they look good then as you say it must be how you are writing back to SAP that is the problem. I think you need to provide more details on how you are doing that.

Re: SAS Support Communities metrics and their trends

SASKiwi — Mon, 03 Aug 2026 21:30:36 GMT

Personally, I've found it more productive to use Google for SAS questions as it provides AI answers, SAS documentation links, SAS Support links, SAS Community links all in one go and with a much higher chance of finding relevant answers. That's the competition that the SAS Community faces.

Re: Users unable to access the certain application. So, need to troubleshoot the issue

SASKiwi — Mon, 03 Aug 2026 04:49:15 GMT

Given this is a SAS-supplied product, opening a track with SAS Tech Support is the best option.

Re: "not sorted in ascending sequence" error despite sorting that way in prior step

SASKiwi — Thu, 30 Jul 2026 03:44:51 GMT

If you can't reproduce the problem then I suggest you "park" it until it reappears 🙂

Re: "not sorted in ascending sequence" error despite sorting that way in prior step

SASKiwi — Wed, 29 Jul 2026 23:10:14 GMT

Take a look at these two notes:

PROC SORT:

NOTE: The data set WORK.TMP has 6636340 observations and 110 variables.

PROC RANK:

NOTE: There were 997665 observations read from the data set WORK.TMP.

I can only assume that the TMP data SORT processes is NOT the same as the TMP dataset RANK processes as the observation count doesn't match. Why would that be? Are we missing some processing between the SORT and the RANK?

Re: Syncing Report Data whilst using SAS Viya 25.09 (Visual Analytics)

SASKiwi — Tue, 21 Jul 2026 01:18:09 GMT

@ed_hcf - Could the reason for the duplication be two different variables with the same variable label? You can check this by running PROC CONTENTS on shrdat.ea_rc_fc_metrics2

Re: Evolving Disaster Recovery: Real-time Replication

SASKiwi — Tue, 07 Jul 2026 04:44:32 GMT

@EyalGonen - From what I understand, PureStorage also have a cloud-based solution that should also work with SAS Viya. AFAIK, it functions like a real-time backup and restore so doesn't involve any file replication at all. Perhaps you could ask SAS if they know of any Viya customers using this technology.

Re: Evolving Disaster Recovery: Real-time Replication

SASKiwi — Mon, 06 Jul 2026 22:51:01 GMT

FYI, we have implemented a SAS 9.4M8 Disaster Recovery solution using a data centre technology called PureStorage. When we failover to our DR data centre, PureStorage simply reinstates the required storage in it's last recorded state so the avoids the requirement for replication completely. As far as SAS is concerned PureStorage drives are just like any traditional storage so no special configuration is required. It works like a charm for us.