I am trying to get SAS data into my Excel spreadsheet and my below code can get the data from SASHelp library but not from WORK library. Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
sas.InsertDataFromLibrary "SASApp", "SASHelp", "CLASS", Sheet1.Range("A1") But after copying the CLASS data to WORK library in SAS EG proc copy in=sashelp out=home;
select class;
run; And changing the VBA code in my Excel to sas.InsertDataFromLibrary "SASApp", "WORK", "CLASS", Sheet1.Range("A1") It gives me the below error: Has anyone encounter the same issue and how did you resolve this? Thanks for your help 🙂
... View more