SQLite is an open-sourced relationship database management system with full functionality [Ref.1]. The light-weight (300k+ size) and zero configuration features distinguish it from its’ 800-pound counterparts like Oracle or MySQL. Thanks to the rise…
Category: SAS
SAS Grid Series – What, Why and How
SAS Grid computing has been around for a while, and while there is a lot of information available on SAS Grid, I found it incredibly hard to get a succinct view on how you would and wouldn’t deploy SAS Grid in an environment. This series will outline what I found. I will add each article […]
Flush with excitement…errr, logs
Well, it is Friday night, I am back from the doctor with antibiotics due to a possible spider bite (love those little guys), and I decide to track down some performance issues with the SAS StoredProcessService (or Microsoft’s Cassini). Somewhere, someo…
Delete non-exact duplicates in SAS
When deleting non-complete duplicates in SAS, in each duplicate set you may want to keep a particular record identified by a rule: it may be the oldest, newest, first, or last observation in each set. You need a identifier to be unique, but you canR…
Highlights of SGF 2011
I’ve been so busy over the last month that I am just now getting a chance to sort through my notes from SAS Global Forum 2011. Here are a few highlights I found: SAS OnDemand for Academics SAS OnDemand for Academics (the cloud computing version of SAS) will be free for academic research starting in […]
Web Report Studio 4.3 Roles (and hiding the Edit Tab)
Doing some work to figure out how to remove the Edit tab for a user in WRS 4.3. Found this table of roles for WRS on the SAS Support site here: Predefined Roles and Capabilities for SAS Web Report Studio By the way the trick on the edit tab is to make sure PUBLIC doesnt […]
SAS makes spreadsheet for reporting
Excel is the last stop in the pipeline of my daily work. Most clients of mine like colorful multi-sheet spreadsheets more than plain CSV files (I guess they all use Windows). I am not a power user of Excel, and honestly I am a little afraid of it: so…
Example 8.37: Read sheets from an excel file
Microsoft Excel is an awkward tool for data analysis. However, it is a reasonable environment for recording and transfering data. In our consulting practice, people frequently send us data in .xls (from Excel 97-2003) or .xlsx (from Excel 2007 or 201…