Select Page

SAS SCL Lists (slists) – an Overview

What is SCL? Mention AF or SCL to someone who has been in the SAS game for more than a decade or so, and you can be sure there will be a story to tell.  The technology, built by pioneers such as Deva Kumaraswamy, was used to build many of the original SAS client...

Find MIN / MAX of character variables in sql

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; create table...

The Performance of Dosubl vs Call Execute

Both dosubl and call execute accept raw SAS code as input.  The difference between them is that call execute will take your code and add it to the stack (so, after your data step completes) whilst dosubl will execute your code immediately. Dosubl is a fantastic...

About the SAS London Users Group (SLUG)

The SAS London Users Group (SLUG) is a London-based user led community dedicated to realising the value of SAS software.  Sounds great.  But what does this actually mean? London Based Whilst our meetups take place in London, users are welcomed from across the UK and...