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.