The Journal of Accountancy had a good article last month on building Excel-based dashboards. It got the creative juices flowing for me, and I am thinking about integrating some dashboards into my daily work. Modern BI tools like SAS and … Continue reading →
Tag: Tech
SAS EG: Filtering a dataset via prompt manager variable
Nobody who reads this blog is likely a SAS programmer. However, on the off chance this would be useful to someone who finds it via Google, I wanted to post. Currently, I am working on a project in SAS Enterprise Guide where I needed to allow the user to provide variable value(s) via prompt manager […]
DO Loops: Part Deux (It’s a pun. Get it?)
For Part II in this series of posts on DO Loops in SAS, I wanted to discuss an application slightly more complex than the previous example. Loops can not only be used to perform data correction (as shown in the previous post), but can also be very useful in creating new records where none exist. […]
DO Loops: Useful Tool in SAS User’s Toolbox
DO Loops in SAS are outside the scope of what most beginning users feel comfortable tackling. However, they are a powerful, time-saving tool in the report writer’s toolbox. For those unfamiliar with programming, loops are a set of instructions that the programmer tells the computer to repeat until predefined condition(s) are true. It’s a simple […]
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 →