Return to site

Pull specific data from multiple excel for mac files into one

broken image

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.

broken image

I have a love-hate relationship with spreadsheet data.