Today, whilst trying to troubleshoot why a SAS Environment Manager Service Architecture configuration was no longer collecting and processing logs, I discovered a handy status option for the emi_init command. I’m posting the help output and status output here to remind me in future 🙂 Here’s the output from the emi_init help option showing all … Continue reading “SAS Environment Manager Service Architecture: emi_init”
Tag: SAS
WUSS 2016: The Papers
The Western Users of SAS Software 2016 conference is over. I have been to a lot of SAS conferences, but WUSS is always my favorite because it is big enough for me to learn a lot, but small enough to be really friendly. I’m already excited about next year’s conference in Long Beach, September 20-22. […]
SAS ERROR: Cannot load SSL support. on Microsoft Windows
When using SAS with HTTPS or FTPS, which requires SSL/TLS support, you may see this error message in the SAS log.
ERROR: Cannot load SSL support.
Here is an example of code that can trigger the error.
filename myref url "https://www.google.com";
data _null_;
infile myref;
run;
The cause was that
For more posts like this, see Heuristic Andrew.
Suppressing SAS Workspace Server MVA_DSIO.OPEN_CLOSE and _DISARM Messages
This is just a very quick post to jot down the location of a SAS reference that I keep losing! I have the SAS Audit, Performance and Measurement (APM) package installed in my older SAS 9.4 M0 dev/test environment. The APM package is now deprecated as the functionality has moved into SAS Environment Manager (from … Continue reading “Suppressing SAS Workspace Server MVA_DSIO.OPEN_CLOSE and _DISARM Messages”
SAS error "insufficient memory" on remote queries with wide rows
SAS can give the error The SAS System stopped processing this step because of insufficient memory when querying a single, wide row from a remote SQL Server. The following code fully demonstrates the problem and shows a workaround. Also, I eliminate the explanation that SAS data sets in general do not support rows this wide.
For more posts like this, see Heuristic Andrew.
Reusing calculated columns in Netezza and SAS queries
Netezza and SAS allow a query to reference a calculated column by name in the SELECT, WHERE, and ORDER BY clauses. Based on the DRY principle, this reduces code and makes code easier to read and maintain.
Some people call calculated columns derived or computed columns.
In Microsoft SQL Server, SQLite, and other RDBMSs you cannot exactly do this: a workaround is to reference a subquery or view. In Microsoft SQL Server, you can also define a computed column on a table.
Below is an example tested with Netezza 7.2. Notice height_m is used in the SELECT clause, and bmi is used in the WHERE and ORDER BY clauses.
For more posts like this, see Heuristic Andrew.
R Passes SAS in Scholarly Use (finally)
Way back in 2012 I published a forecast that showed that the use of R for scholarly publications would likely pass the use of SAS in 2015. But I didn’t believe the forecast since I expected the sharp decline in SAS … Continue reading →
Rexer Data Science Survey: Satisfaction Results
by Bob Muenchen I previously reported on the initial results of Rexer Analytics’ 2015 survey of data science tools here. More results are now available, and the comprehensive report should be released soon. One of the more interesting questions on the survey … Continue reading →