SAS offers many ways to read from and write to Microsoft Excel spreadsheets. Likewise, saving results as a spreadsheet can lose something in the translation - usually value formatting, appearance attributes, or graphs. Ī spreadsheet is not a database, so it can be a challenge to whip spreadsheet data into analysis-ready shape. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can then manipulate further. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it.
I have a love-hate relationship with spreadsheet data.