As you can tell from my recent posts (see here and here), I’ve been working with SAS and Microsoft Excel files quite a bit. I’m really enjoying the ability to import an XLSX file in my 64-bit SAS for Windows without any additional setup. After one long afternoon of back-and-forth […]
The post Don’t panic: maybe your XLSX file is already opened appeared first on The SAS Dummy.
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…
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…
I have a spreadsheet where one column has character lengths ranging from 0 to 1000 or even more. Importing them has never been much of a problem with this code:
PROC IMPORT DATAFILE=”F:\path\to\file.xls”OUT=work.aDBMS=excel2002 REPLACE;SHEET=”Sheet1″;…