Tag: excel

How do I export from SAS to Excel files: Let me count the ways

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 […]

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…