If you use the SAS^® Add-In for Microsoft Office to open data in an Excel spreadsheet, make changes to that data, and then attempt to save those changes using SAS→Active Data→Copy to SAS Server, you might save the original data to the table instead of the modified data in the spreadsheet.

When you select SAS→Active Data→Copy to SAS Server from the menu, you must follow these steps in order to copy the modified data in the spreadsheet.

1. Make sure that you have row numbers showing in your spreadsheet.

2. If you are not showing row numbers, you can turn them on in the SAS Add-In Options dialog box. Select SAS→Options and change the value of Insert row numbers in the first column to Always. After making this change, you must refresh your results in order to display the row numbers. You can refresh your results by selecting a cell in your data and then selecting SAS→Refresh.

3. Select the variable names and values in the spreadsheet that you want to copy. When you select the columns and rows, do not select the row numbers.

4. Make sure that the Active Data field in the SAS Analysis toolbar displays Active Selection.

5. Select SAS→Active Data→Copy to SAS Server to copy the modified data. Make certain the Copy to SAS Server dialog box shows only Workbook, Worksheet, and Range information. The dialog box should look similar to the following:

Note: If your dialog box contains information for the SAS Server, Library, and Data Set as well as the ones listed above, then you are not copying the modified data, but rather the original data that is referenced in the Data Set field. Here is an example of what the wrong dialog box might look like:

6. If your dialog box looks like the first screen shot in step 4 (that is, it contains only Workbook, Worksheet, and Range information), then your last step is to select your destination at the bottom of the Copy to SAS Server dialog box and save the modified data to your desired table.