Hi Linus, Thank you for the reply. The first question is the tricky one and the answer to it will probably solve my problem. Sorry for being a bit of a newcomer to all this, but I am using the same profile when logging into SAS on every account. I've created a very simple table in EG (new Data - two variables a (numeric) and b (character)) and keep it in a pre-assigned library (I assume it's pre-assigned, it is under SASApp:Libraries in Enterprise Guide when I open it. I.e. I haven't created a special library through a libname statement). I have no problem with accessing that table through the Excel Add-in. Then I created a very simple view in SQL (proc sql; create view EGREPCD.view_test as select sum(a) where b="x";). I can access the view via EG without problem. Even having two instances of EG will allow me to update the values in the table in one and see the view change in the other. However, trying to access the view in Excel throws the error. I guess the problem lies in the simple SQL? Even if EG understands it, taking it a step further (into the Excel Add-in) is too much. If that is the case, is there a way for me to register the view in meta data? I have DI Studio if that matters. Thanks a lot, Agnar
... View more