I have a love-hate relationship with spreadsheet data. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I’ll take it. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can […]
Tag: excel
Behind the scenes: importing Excel files using SAS Enterprise Guide
I hope that the following statement is not too controversial…but here it goes: Microsoft Excel is not a database system.
That is, I know that people do use it as a database, but it’s not an application that supports the rigor and discipline of…
Example 8.38: WriteXLS to create spreadsheets
In our last entry, we described reading Excel files. In this entry, we do the opposite: write native Excel files.RIn R, the WriteXLS package provides this functionality. It uses perl to do the heavy lifting, and the main complication is to install th…
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…
JoA: Dashboard Your Scorecard
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 →
SAS Macro to put SAS data into Multiple Excel Work sheets
I believe most of us have encountered this situation…
I have a sas dataset with more than 70k records…How can I provide this information in an Excel file to the business user….
If one is using previous versions of MS Excel ie. < Excel 2007 th…
Too Big to Be Accurate(1): Which is the Most Powerful Calculator in the World?
Calculate the factorial of 171 (171!)? Just TRY! It is equal to 171*170*169*….2*1.
1. Google calculator
As Google fanatics, I first try to search the answer via Google:
Whoops, nothing interested returned! Type “170!” and get the output:
Why kinda things happened in this calculator? 171! is just equal to 171*170!.
2. Excel
Switch to Excel spreadsheet. Function fact(*) […]
Who am I to judge?
Tomorrow I’ll be taking a few hours away from work to build something important: the self-esteems of a handful of middle-school-aged children.
I’m volunteering as a judge in a middle-school science fair. And even though I’m not a scientist (“com…