Desktop productivity for business analysts and programmers

Updating SAS import dataset

Reply
N/A
Posts: 0

Updating SAS import dataset

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
Community Manager
Posts: 2,884

Re: Updating SAS import dataset

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Updating SAS import dataset

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 4.1.0.1010


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