Desktop productivity for business analysts and programmers

Import Data versus Open Data

Not applicable
Posts: 0

Import Data versus Open Data

Is there any difference whether I use File>Import Data and File>Open>Data from a the same Excel file?
Trusted Advisor
Posts: 2,127

Re: Import Data versus Open Data

Posted in reply to deleted_user

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
Not applicable
Posts: 0

Re: Import Data versus Open Data

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

Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation