Moving existing AMO content in Excel to a new location

ScottBass · Posted 01-23-2013 05:45 PM

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

Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.

ScottBass · Posted 01-25-2013 08:23 AM

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

Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.

DBailey · Posted 01-25-2013 11:12 AM

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?

Moving existing AMO content in Excel to a new location

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

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