Tag: SAS

NOTE: Unable to Write to Template Store!

Sometimes you get into a habit that is so deep-seated that you don’t realise you’re doing it. I was just reminded of a little trick that I regularly use when editing ODS graphics templates.

A colleague of mine was using PROC TEMPLATE and getting the f…

NOTE: Ampersands Again

My recent post on double and triple ampersands in macros ended with some doubt. Laurie and Dave immediately took up the challenge to resolve the doubt. You can see the whole painful saga in the comments of the original post, but I’ve repeated Dave’s…

NOTE: SEUGI Proceedings

Did I miss this? The proceedings of the SAS European User Group International (SEUGI, the European equivalent of SUGI and SGF) are now all online on the SAS Community web site. Papers from 1983 to the last event in 2007 are there.

Most of the pages we…

NOTE: Getting More for Less With SPDE

Would you like to read or write your data more quickly? SAS V9.1 introduced Scalable Performance Data Engine (SPDE, “Speedy Engine”), for free. Are you using it? Speedy Engine is the little cousin of Speedy Server (Scalable Performance Data Server, a…

NOTE: Quick SAS Keyword Search in Chrome

Did you know that the Google Chrome browser allows you to specify multiple search engines, accessible by a short keyword? Well, I didn’t until last week when my mention of Visuwords (graphical dictionary & thesaurus) made me wonder if there was s…

NOTE: The Dreaded Double and Triple Ampersands

Aside from Chris Hemedinger’s comment on SAS V9.3’s PROC SQL INTO enhancements, my Macro Arrays, Straight From a Data Set article last week also caught the attention of another friend and regular correspondent – LeRoy Bessler. LeRoy emailed m…

NOTE: SQL INTO, Revisited

In Macro Arrays Straight From a Data Set last week I wrote about using SQL’s INTO in order to create macro variables (and arrays of macro variables) from PROC SQL. I said that we had to use an arbitrarily large number to define the maximum size of the …