Actually I am writing a code in Excel-VBA to run a sas program i.e. sub sas()
Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("Sas.ExcelAddIn").Object
Dim prompts As SASPrompts
Set prompts = New SASPrompts
Dim rng As Range
Set rng = Worksheets(1).Range("A1")
Dim cov As String
prompts.Add "STATS", cov
sas.InsertStoredProcess "/User Folders/klj/My Folder/Stored Process for Program 6", rng, prompts
end sub This code is wriiten in VBA and so I dont have any export code in SAS to impose if condition on it. This VBA code connects to SAS and runs the stored process for program 6. Everything is fine but it automatically imports all the created output data set so I wanted to know is there a condition which can be placed in Excel-VBA Add in to import data only when the user want else only run the program.
... View more
