Reading .sas7bdat file in sql managment studio

[Jose7]

Hi experts!

I have copied some .sas7bdat files in a sql server database and i want read the data using sql managment studio or reporting services

Is there a way to do so??

[SASKiwi · Accepted solution]

SAS datasets use a proprietary format so you can't read them from SQL Server Management Studio. Do you have SAS available to you so you can load SAS datasets into SQL Server? You need the SAS product SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC to do this.