SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

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

Reply
Occasional Contributor
Posts: 15

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

[ Edited ]

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.

Occasional Contributor
Posts: 15

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

[ Edited ]

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.

Post a Question
Discussion Stats
  • 1 reply
  • 144 views
  • 0 likes
  • 1 in conversation