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

Moving existing AMO content in Excel to a new location

Reply
Super Contributor
Posts: 374

Moving existing AMO content in Excel to a new location

Hi,

Apologies if I've missed this in the doc and/or user interface...

Say I create SAS content in Excel via AMO, for example loading SASHELP.CLASS into $A$1.  Later I decide I want to move the location to $A$10 (for example to add some explanatory text above the content).

Is there a way to move the existing content, or do I need to delete and recreate it?

Thanks,

Scott

Super Contributor
Posts: 374

Re: Moving existing AMO content in Excel to a new location

Bump.  Surely there must be a way to move SAS content after it's first created???

Super Contributor
Posts: 578

Re: Moving existing AMO content in Excel to a new location

I was able to move sas content by selecting the entire table, cutting and pasting it to a different location in the same workbook.  I was also able to insert rows by selecting the top row of the data table and just inserting them.  What's happening when you try?

Ask a Question
Discussion stats
  • 2 replies
  • 261 views
  • 0 likes
  • 2 in conversation