topic Re: Moving existing AMO content in Excel to a new location in Microsoft Integration with SAS

Moving existing AMO content in Excel to a new location

ScottBass — Wed, 23 Jan 2013 22:45:11 GMT

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

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

ScottBass — Fri, 25 Jan 2013 13:23:35 GMT

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

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

DBailey — Fri, 25 Jan 2013 16:12:43 GMT

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?