topic Import Data versus Open Data in SAS Enterprise Guide

Import Data versus Open Data

deleted_user — Mon, 12 Nov 2007 08:40:25 GMT

Is there any difference whether I use File>Import Data and File>Open>Data from a the same Excel file?

Re: Import Data versus Open Data

Doc_Duke — Mon, 12 Nov 2007 17:52:56 GMT

yes.

Import data (and the create a SAS dataset option under File>Open>data) create a SAS dataset from the excel sheet. To re-import, you have to re-run the task.

file>open>data also allows you to open the excel file "in place" so changes to the excel file appear immediately to the project.

IMHO, import data allows a little more flexibility at the expense of immediacy.

Doc Muhlbaier

Re: Import Data versus Open Data

deleted_user — Wed, 14 Nov 2007 02:11:45 GMT

I agree, and I have a number of memories of batches and projects failing because one piece of software locked something required by another.

Excel was a particular issue, but then often the Excel objects were not created for the SAS process but used as an input. It would be unkind to blame Excel for blocking something it wasn't designed to do.

Import will allow the data to be taken (and the import to be bypassed in some project updates if required), whereas Open will require that a file lock can be obtained every time the project is opened.

Kind regards

David