Posts Tagged ‘ Proc Import ’

Don’t panic: maybe your XLSX file is already opened

September 24, 2014
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off

Behind the scenes: importing Excel files using SAS Enterprise Guide

May 18, 2011
By

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...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

Example 8.37: Read sheets from an excel file

May 11, 2011
By

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...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

SAS needs to fix Excel import for fields greater than 255 characters

February 11, 2010
By

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";...
Read more »

Tags: ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.