SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Change libname of existing SAS Add In content

Posts: 33

Change libname of existing SAS Add In content

We have recently both upgraded from SAS 9.1 to 9.2 and completely changed our library structure. I am now attempting to get an Excel spreadsheet created in our previous environment to workin the new one. I have re-created the source table but it is now in a different library. Whenever I try to access/modify the data coming into the spreadsheet I get an error telling me the library cannot be found (which I know!).

Is there a way of amending the source data?
Posts: 9,028

Re: Change libname of existing SAS Add In content

If you are working in the context of the SAS Add-in for Microsoft Office in the Enterprise Intelligence Platform, then it was my understanding that you needed to follow a migration plan, not merely upgrade SAS on the servers.

I believe that Metadata changes were implemented between 9.1 and 9.2 that involved some restructuring and reconfiguring, as described in the documentation on migrating content:

You should work with your SAS Administrator and possibly, with Tech Support, to be sure that the migration at your installation worked correctly.

Respected Advisor
Posts: 4,274

Re: Change libname of existing SAS Add In content

There is in the SAS EG 4.2 directory a MigrationWizard.exe which can be used to migrate MS Excel files from 9.1 to 9.2.

I'm not sure if this will solve all of your issues with the Excel migration - but the tool will help you to re-map file and library definitions. Just give it a try.

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