In the SAS Add-In 5.1
for Microsoft Office, you can open documents that contain SAS content
that was generated with prior releases 2.1, 4.2, or 4.3.
For documents that were
generated with the 2.1 release of the SAS add-in, refreshing the SAS
content changes that content to the 5.1 format. Thereafter, the SAS
content cannot be refreshed in the 2.1 release of the SAS add-in.
For documents that were
generated with the 4.2 or 4.3 release of the SAS add-in, you can refresh
the SAS content to the 5.1 format and then open the documents in the
4.2 or 4.3 version of the SAS add-in.
If you refresh a document
from any previous release, and if you add new content in the 5.1 release,
do not open the 5.1 document in any previous release.
Content that was generated
in the 4.2 or 2.1 release must be refreshed before you can use the
restore content functionality.
If you open content
from the 4.2 release and the
Show Preview Changes dialog
box check box is selected on the
Results tab
in the
SAS Options dialog box, then you can
select what content to include in the results and what content to
hide. However, because this is migrated content, the SAS add-in might
not find the original results to know which content to hide. If the
SAS add-in cannot find the original results, then all of the results
are displayed.
To ensure that you are
using the latest version of the data, refresh any data sources in
your document before you use this data in the SAS Add-In 5.1 for Microsoft
Office. For example, measures that were available to a PivotTable
in the 4.3 release might not be available in the 5.1 release because
you are connecting to a different server for the 5.1 release. When
you refresh your data, any measures that no longer exist are removed
from the PivotTable.
When you refresh a document
from a previous release in the 5.1 release, you might notice that
the style for the output has changed. To work around this problem:
-
Before you refresh the
content in 5.1, select the content in Microsoft Excel, Microsoft Word,
or Microsoft PowerPoint, and then click
Properties.
-
In the
Properties dialog
box, select the style that you want to use, and then refresh the content
in 5.1.
To migrate multiple
files or to remap references to metadata objects (such as servers,
libraries, information maps, and stored processes), use the migration
wizard. To run this wizard, double-click MigrationWizard.exe in the
directory where you installed the SAS Add-In for Microsoft Office.
After you open the wizard, click
Help for
more information about the migration options.