CODEWITHSUNDEEP
excelvbasas
kibicrealu1
kibicrealu1

Reputation: 53

SAS Add-In for Microsoft Office: Excel & Stored Process - don't show external database table in a separate tab

In Excel I am executing a stored process that in last step creates a table in external database (Teradata):

data teradb.a;
set b;
run;

When this is executed, new sheet in Excel with its contents is also created. How can I prevent this from happening? I just want teradb.a to be created, don't need a separate worksheet in Excel with it...

I execute stored process in vba using following code:

Dim SAS2 As SASExcelAddIn
Set SAS2 = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
Dim streams As SASRanges
Set streams = New SASRanges
Sheets("Entry Criteria").Range("J9").Clear
streams.Add "XcelData", Sheets("Entry Criteria").Range(Cells(4, "D"), Cells(25, "F"))
SAS2.InsertStoredProcess "/system/UpdateParameters", Sheets("Entry Criteria").Range("J9"), , , streams

I was playing with ODS options or using proc sql with NOPRINT option, but this doesn't help. Would highly appreciate your suggestions!

EDIT: As requested - some screens with stored process properties : enter image description here

enter image description here

enter image description here

Upvotes: 2

Views: 982

Answers (1)

kibicrealu1
kibicrealu1

Reputation: 53

Solution turned out to be in the Tools -> Options of SAS ribbon in Excel. Unchecking "Open output data automatically" under "Output Data Sets" section in "Data" tab did the trick.

Upvotes: 1

Related Questions