A recent upgrade from SAS 9.1 to 9.2 necessitated an upgrade from Enterprise Guide (and Add-In for Microsoft Office) 4.1 to 4.3 for one of my clients. Disappointingly, the EG and Add-In upgrades didn’t prove to be the smoothest, and the exper…
Do I have to choose between Excel and SAS?
This question came up while helping my presales colleague with a client’s question: “Is Microsoft Excel in direct competition with SAS?” Not really. I like to think of SAS as partnering with Excel. Because of the following Excel benefits and its …
NOTE: Enterprise Guide 5.1 – Now Shipping!
If you haven’t already picked-up the news from elsewhere, I should tell you that Enterprise Guide 5.1 (EG 5.1) started shipping earlier this month. For SAS 9.2 and 9.3 only* at this point in time, EG 5.1 looks like it adds some decent new functionality…
Rails and Recent d3.js Examples
A lot of my free time has been spent running and developing a running log using rails. I want greater control of monitoring / visualizing each training cycle than the sites out there will let me have (no API’s..). Thus, I’ll just build my own! This whole thing was spurred by my dabbling in […]
What Can I Do With a Stored Process?
Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to Web Report Studio and Linking to a Stored Process from Web Report Studio. Add-In for MS Office – View Reports or Data Use the stored process to deliver a report or maybe just a dataset (using Proc Print) to the Add-In for Microsoft Office (AMO). In the past, I set up several stored processes that only contained a PROC PRINT to display a data set. Then I added a prompt for Product, which allowed the user to query product inquiries based on the product of interest. Here’s how you access the stored process from AMO 4.3. This works similarly in prior versions of AMO. Open MS Excel (or Word/PowerPoint). On the SAS ribbon, click the Reports icon. Navigate to the stored processes storage location and click the stored process name. < Optional> This stored process has two prompts: Visitor Type and ODS Style. Your stored process […]
Transcoding Problem: Option (correctencoding=wlatin1)
Have you ever tried to convert the default encoding to Wlatin1 (Windows SAS Session Encoding)?
Let me tell you the story behind writing this post….
Today I was asked to send SAS datasets to one of the client. I transferred the SAS datasets to th…