(Note: All the followings are tested on Windows XP environment.)
0. Install Oracle Database 10g Express Edition
Fast (and free) to download, easy to deploy and simple to admin–for learning and testing purpose, Oracle Database 10g Express Edition (Oracle Database XE, a mini version of Oracle Database 10g Release 2) are strongly recommended:
0.1 Download it at […]
Tag: SAS
SAS INTNX function ( add days, months, years, etc )
The INTNX function increments dates, times, or datetimes by specific or custom intervals. Here is the basic syntax for INTNX: INTNX(interval[multiple.shift-index], start, increment[, alignment]) The interval can be a set value like – DAY, WEEK, DTWEEK, YEAR, etc. You can also specify a custom interval. We will post more on that later. The multiple is […]
Actuarial Triangle: Powerful Tool for Accounting Estimates
When individuals outside the profession think of accounting, they don’t often consider its subjective nature. Most people assume there are bright line rules and it’s the CPA’s job to make sure the rules are adhered to. In some instances, there … Continue reading →
My SAS Christmas List
Lovin’ the retro SAS swag! hrenee posted on twitter the sasmemories site on flickr. It’s the start of a good collection of SAS goodies.
This reminds me, here are some items I’d like for Christmas:
Oddball t-shirts like those at T-shirt Bordello,…
Continuous Reboot Message when Installing SAS 9.2 and EG 4.2
During the SAS 9.2 Deployment Wizard I was continually getting a message saying I had to reboot the machine. After rebooting 3 times I new something was up. Some searching on support.sas.com revealed the following fix:
Locate HKEY_LOCAL_MA…
SAS DIM function – Counting the elements in an array
The DIM function returns the number of literal elements in an array. It functions against multi-dimensional arrays as well as one-dimensional arrays. 1-dimensional array example DIM(array_name) Multi-dimensional array examples DIM(m_array) -> returns the number of elements in the first dimension of the array DIM5(m_array) -> returns the number of elements in the 5th dimension of […]
SAS DIF function – Comparing previous records
The SAS DIF function is another useful tool for operating on previous records. Lets say you want to know the difference in the last year’s revenue and this year’s revenue. Here is the data: Year Revenue 2001 10,000 2002 30,000 2003 60,000 2004 100,000 data revenue1; set revenue; Rev_increase=dif1(revenue); run; Year Revenue Rev_increase 2001 10,000 […]
SAS: “The query requires remerging summary statistics back with the original data”
Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sq…