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 […]
Calculating the number of working days between two dates
It’s a simple task to use SAS to compute the number of weekdays between two dates. You can use the INTCK function with the WEEKDAY interval to come up with that number.
diff = intkc(’WEEKDAY’, start_date, end_date);
If you want to c…
Calculating the number of working days between two dates
It’s a simple task to use SAS to compute the number of weekdays between two dates. You can use the INTCK function with the WEEKDAY interval to come up with that number. diff = intck(’WEEKDAY’, start_date, end_date); If you want to compu…
NOTE: Know Your Customers (Before They Know You)
I’m a fan of BBC reporter Rory Cellan-Jones’s blog. Just before jetting off to SAS Global Forum in April I noticed a most interesting article from Rory entitled World Stores – searching for retail success. The article talks of the success of …
NOTE: Taking a Risk?
A tweet by Manoj Kulwal (global product manager for SAS Enterprise GRC) a couple of weeks ago drew my attention to a Compliance Week article describing how the US Securities and Exchange Commision (SEC) had (for the first time) brought financial penalt…