topic Re: Updating SAS import dataset in SAS Enterprise Guide

Updating SAS import dataset

deleted_user — Tue, 15 Dec 2009 21:27:31 GMT

Hi,
I imported an excel file into SAS EG using File --> Import Data. The data is located on a server accessed by my local computer.

I changed the file by adding additional rows. I was hoping if I just reran the import data function, the additional rows would be added, but they are not. How can I add the extra rows without doing it manually and without re-importing the file.

Thanks in advance! Message was edited by: ILGator

Re: Updating SAS import dataset

ChrisHemedinger — Wed, 16 Dec 2009 14:44:49 GMT

If you saved the Excel file and then re-ran the import task, the data *should* be updated.

If this is the 4.1 release, please verify that you are running with the latest hotfixes (should be something like 4.1.0.1010 in the Help->About window).

If the problem persists, you should work with SAS Technical Support to help resolve it.

Chris

Re: Updating SAS import dataset

sbb — Wed, 16 Dec 2009 16:46:10 GMT

Please clarify this statement (at least for me):

I changed the file by adding additional rows

Exactly where did you change "the file" -- after importing it into SAS or in the external file, for which you need to import it again, likely replacing the prior imported file?

Scott Barry
SBBWorks, Inc.

Re: Updating SAS import dataset

Flip — Wed, 16 Dec 2009 18:33:35 GMT

I have experience this behavior as well. Once EG creates a temporary file, it does not go back to the spreadsheet to refresh the data.
I have changed data, saved the excel file the re-run the import, and get the same data. I am on 4.1.0.1010

Message was edited by: Flip