Posts Tagged ‘ Proc Import ’

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: [email protected]

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.