Modernising Legacy SAS SCL / AF Applications

Before SAS Studio, and even EG (but after display manager), there was a desktop application used exclusively for accessing SAS. It was known as Base SAS, and within it there was an application development facility known as SAS/AF. This enabled point and click...
Using CURL with SAS Stored Processes

Using CURL with SAS Stored Processes

I’ve said it before and I’ll say it again – SAS is an unparalleled platform for lightning fast development of enterprise-grade, business focused web applications.  Not least because it comes pre-installed with a Web Server and an incredibly powerful...

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...