• cs_source (1/3/2013) If you like i can post the SAS code? 🙂

    Not the code for percentile, but if you can figure out a way to use OPENROWSET with the SAS OLE providers I would sure appreciate it. I am able to use VBA in Excel to read SAS files, and to use the import wizard in SQL Server to import .sas7bdat files, but for the life of me I can't get OPENROWSET to work with the same SAS providers that Excel has no problem with.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.