i tried run sas code through vba. i'm running sas on server. have test sas program "program1.sas" i've kept on server. below vba code i've used. sas code running output dataset showing column headers , rows empty.can me possible reason.
sub form_load23() dim obobjectfactory new sasobjectmanager.objectfactory dim obobjectkeeper new sasobjectmanager.objectkeeper dim observer new sasobjectmanager.serverdef dim obsas sas.workspace dim cn new adodb.connection dim rs new adodb.recordset observer.machinednsname = "xyz" observer.protocol = sasobjectmanager.protocols.protocolbridge observer.port = 8871 obobjectfactory.logenabled = true set obsas = obobjectfactory.createobjectbyserver("sas", true, observer,"userid", "password") obsas.languageservice.submit ("options source2; %include '/abc/afp/shikhar.gupta1/amg/**program1.sas**';") end sub'
Comments
Post a Comment