Get Physical Path From Metadata Libref

So it turns out that it is not possible to place a SAS lock on a table referenced via the Metadata Libname Engine:

WARNING: LOCK is not supported in MLE.

To c...

Use OR condition in metadata OMSOBJ query

Make your metadata queries more versatile by checking for multiple conditions in a single pass!  When using the OR condition, remember to prefix subequent attributes with the @ symbol.  See below for testing whether a Stored Process user is in a c...

Platform Computing - LSF documentation

In building a script to read in the LSF log files (lsb.events files), it was apparent that the file structure has changed across LSF versions.  What is not so apparent is where the documentation resides..  So here’s  a quick ref guide.

...

VBA and SAS IOM - applying formats

Sample code (and tips) for applying SAS Formats to data before pulling into excel:

Dim obConnection As 

Improve performance of DI Studio client

You can speed up the performance of your DI Studio client by increasing memory via the JavaArgs_1 variable in the distudio.ini file.  A suggested approach is to increase from -Xmx512m to -Xmx1024m.

Allow XCMD on the workspace server

Paul Homes has an excellent explanation of this..  The below may be helpful as a simple quick reference guide.

ssh: connect to host bitbucket.org port 22: Bad file number

Phew - 4.5 hours later, the problem is solved!  Let me save you 4 hours and 25 minutes, if you are submitting / getting the response below when trying to connect to your GIT repository from within a company firewall (on Windows):

Debugging Stored Processes

Debugging Stored Processes

One challenge that developers have when working with stored processes, is access to the work library.  Whilst sessions can be configured to persist, this does not help if you want to view a snapshot of you...

Configuring Base SAS to show column NAMES by default (instead of labels)

Who cares about labels anyway?!!

Ok, first select explorer in base sas, then tools / options / explorer:

Copy All Files From One Directory To Another

EDIT (2021): The mp_copyfolder macro in the SASjs Core library is now available, and is far preferable to the origin...

« Older EntriesNext Entries »