After Querying Data to pull data into your sheet, you can edit cells and post the changes to the rows you select. Select the data manipulation operation on the CData ribbon. The add-in only saves the changes in the selected rows. You must also enable data modification options for the connection to save changes. See Establishing a Connection for details.

INSERT

To insert a new row, create a new row in the spreadsheet. The data in the columns must match with the respective headers. Select the row and click Update Rows. The CData Excel Add-In for SAS Data Sets attempts to add a new row in SAS Data Sets.

Delete

To delete one or more rows, select the rows and click Delete Rows.

Revert Changes to Records

If you need to undo a mistakenly made change to the data, you can click the Revert Rows button.