SAS如何在VB中调用?

如果安装了以后在VB中选择“库引用”菜单,可以看到
Microsoft ActiveX Data Objects 2.5 Library
SAS: Integrated Object Model (IOM) 1.0 Type Library
SASWorkSpaceManager 1.0 Type Library
代码:
      Dim obWS As SAS.Workspace
      Dim obWSM As New SASWorkspaceManager.WorkspaceManager
     
      Sub Form_Load()
      Dim obConn As New ADODB.Connection
      Dim obRS As New ADODB.Recordset
      Dim errorString As String
     
      Rem start the SAS session
      Set obWS = obWSM.Workspaces.CreateWorkspaceByServer("Local", _
                 VisibilityProcess, Nothing, "", "", errorString)
     
      Rem submit some SAS code
      obWS.LanguageService.Submit _
           "data a; do x=1 to 10; y=10*x; output; end; run;"
     
      Rem open an ADO connection to the data set
      Dim connString As String
      connString = "provider=sas.iomprovider.1; SAS Workspace ID=" _
                   + obWS.UniqueIdentifier
      obConn.Open connString
      obRS.Open "work.a", obConn, adOpenStatic, adLockReadOnly, _
                adCmdTableDirect
     
      Rem write the table as html (visible in Word with tags)
      obRS.MoveFirst
      Dim sTable As String
      sTable = "<TABLE BORDER=0><TBODY><TR><TD class=Data>"
      Selection.TypeText sTable
      sTable = obRS.GetString(, , "</TD><TD class=Data>", _
      "</TD></TR><TR><TD class=Data>")
      Selection.TypeText sTable
      sTable = "</TD></TR></TBODY></TABLE>"
      Selection.TypeText sTable
     
      Rem tidy-up
      obRS.Close
      obConn.Close
      obWS.Close
     
      End Sub
 
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值