Desktop productivity for business analysts and programmers

Updating SAS import dataset

Not applicable
Posts: 0

Updating SAS import dataset

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
Community Manager
Posts: 3,449

Re: Updating SAS import dataset

Posted in reply to deleted_user
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 in the Help->About window).

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

Super Contributor
Super Contributor
Posts: 3,176

Re: Updating SAS import dataset

Posted in reply to ChrisHemedinger
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.
Super Contributor
Posts: 359

Re: Updating SAS import dataset

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

Message was edited by: Flip
Ask a Question
Discussion stats
  • 3 replies
  • 4 in conversation