It would greatly help to provide some example data. You may be looking for a table statement like    tables pat_cnt (grp * trt), region*(n pctn); but can't test that without data. ... View more

Here is a powershell script which works with OleDB and the Share Server: $conn = "Provider=sas.SHAREProvider.;User ID=username;Password=password;Data Source=9999;Location=abc123.xyz.com"; $sql = "Select * from sashelp.class"; $conn = New-Object System.Data.OleDb.OleDbConnection($Conn); $conn.open(); $cmd = New-Object System.Data.OleDb.OleDbCommand($sql,$conn); $ada = New-Object System.Data.OleDb.OleDbDataAdapter($cmd); $table = New-Object System.Data.DataTable; $ada.Fill($table) | Out-Null; $table | Out-GridView; $conn.Close(); ... View more