is it possible to pass %let to an existing EGP from VBA? here is an example of what I'm trying to do: in VBA: dim app dim project dim prjNM 'the SAS EG project set app = createobject("SASEGObjectModel.Application.4.3") prjNM = "c:\text.egp" set project = app.open(prjNM, "") 'add code that allows you to pass %let passme=10 in the SAS code of prjNM a sample code in prjNM libname dat 'sasdata\yada'; proc sql (outobs=[pass the %let passme here; &passme]); create table data as select * from dat.data; quit; thanks in advance!
... View more