topic Excel SAS Addin Refresh duplicating columns off to the right of input data in Microsoft Integration with SAS

Excel SAS Addin Refresh duplicating columns off to the right of input data

cbrotz — Thu, 02 Feb 2017 16:01:43 GMT

We have a large Excel spreadsheet that pulls SAS data through the SAS Addin. In various files, we are finding duplicated columns of data off to the right of the main data in the worksheet after a refresh. This is causing issues with formulas and it sees this as a duplicate and we are getting reference errors....Any suggestions on how to fix would be much appreciated.

Re: Excel SAS Addin Refresh duplicating columns off to the right of input data.

cbrotz — Thu, 02 Feb 2017 16:03:55 GMT

So as a reply to my own post....it appears that the SAS Addin is now pulling in a column A with a counter for some of my datasets. The counter is not part of the data, and I do not see an option to add this. In order for all the data to line up, I added a column A as a blank to the old data sets and now I am not getting that duplicate column in my spreadsheet....at least for now.