Look out - Locale Gotcha
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 If you are getting the following message when importing a package containing a FLOW: 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?... It is perfectly valid to use min() as a summary function on character values in 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. Per... Noticed today that our UAT 9.3 environment was failing to execute the SAS ExportPackage 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: Had an interesting error message today (SAS 9.3, Windows 2012R2), which appeared to be truncated: 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 M... 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 extende...Importing flow: ERROR - An error occurred trying to connect the responsible parties for the imported objects.
SAS As A Service - an easy way to get SAS into Excel, Power BI
Finding MIN (or even MAX) of character variables in SQL
Building SAS Apps Locally
The native implementation module for the security package could not be found in the path.
proc metalib - ERROR: Invalid use of sign notation
SAS/Share ERROR: Invalid object specifi...
Adding SAS Configuration Manager plugin to SMC
Stripping Non-ASCII Characters within Macro
