As gotcha’s go, this was a good one! We had a report being generated with dates that were inconsistent with the source file (MMDDYY instead of DDMMYY), but only for certain records.  This was definitely related to the ANYDTDTE. informat, but the stra...

If you are getting the following message when importing a package containing a FLOW: ERROR - An error occurred trying to connect the responsible parties for the imported objects.  Reason: Can't find resource for bundle java.util.PropertyResourceBund...

When we think about using SAS with Excel, one begins to groan at the myriad of options - DDE, SAS Addin, various Excel-ish library engines, IOM in VBA, etc etc etc. What if there were a simple technique, quick to set up, and easy to adjust? A techniq...

It is perfectly valid to use min() as a summary function on character values in proc sql, eg as follows:proc sql;create table test as    select min(name) as minval  from sashelp.class;This is not so, however, when using in an inline context:proc sql;...

I’ve recently been using Visual Studio to build my SAS Web Apps, which is great as the intellisense will even scan css files to help with code completion.  Perhaps the best feature though is the ability to right click and immediately ‘view in browser...

Noticed today that our UAT 9.3 environment was failing to execute the SAS ExportPackage utility, with the following error returned: The export process has failed.  The native implementation module for the security package could not be found in the pa...

So today I dropped a column in a SQL Server table (using SSMS) and duly checked out the SAS metadata in DI Studio in order to ‘Update Metadata’. It failed with a strange message: ERROR: Invalid use of sign notation. Curious, I extracted the code and ...

Had an interesting error message today (SAS 9.3, Windows 2012R2), which appeared to be truncated: ERROR: Attempt to connect to server "dev01.domain.com".__8551 rejected by server. ERROR: Invalid object specifi... ERROR: Error in the LIBNAME statement...

The SAS Configuration Manager plug-in is great for tweaking settings of the SAS Web Applications without poking around in xml and config files.  However, you may find it missing from the usual place under the Application Management folder in SAS Mana...

Hit once more with a pesky en-dash issue (likely related to the transcoding between SAS & SQL Server) I discovered today there was no ‘in-built’ way to remove non-ascii (or extended-ascii) characters within SAS. There is a great SUGI paper about thi...