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…
Tuning SAS on Windows 2008 (watch windows file cache and I/O)
One of the sessions I got a lot out of at the SAS Global Forum was Margaret Crevar’s session where she outlined what options existed for tuning SAS on Windows 2008. Some recommendations I noted where: On Windows 2008 64-bit size: 4Gb of RAM per core. 1.5 x physical RAM for page file change default SORTSIZE to […]