https://communities.sas.com/t5/SAS-Programming/Reading-sas7bdat-file-in-sql-managment-studio/m-p/810512#M319611 <P>Hi experts!</P><P>&nbsp;</P><P>I have copied some .sas7bdat files in a sql server database and i want read the data using sql managment studio or reporting services</P><P>Is there a way to do so??</P> Thu, 28 Apr 2022 23:33:28 GMT Jose7 2022-04-28T23:33:28Z https://communities.sas.com/t5/SAS-Programming/Reading-sas7bdat-file-in-sql-managment-studio/m-p/810512#M319611 <P>Hi experts!</P><P>&nbsp;</P><P>I have copied some .sas7bdat files in a sql server database and i want read the data using sql managment studio or reporting services</P><P>Is there a way to do so??</P> Thu, 28 Apr 2022 23:33:28 GMT https://communities.sas.com/t5/SAS-Programming/Reading-sas7bdat-file-in-sql-managment-studio/m-p/810512#M319611 Jose7 2022-04-28T23:33:28Z https://communities.sas.com/t5/SAS-Programming/Reading-sas7bdat-file-in-sql-managment-studio/m-p/810520#M319614 <P>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.&nbsp;</P> Fri, 29 Apr 2022 01:39:13 GMT https://communities.sas.com/t5/SAS-Programming/Reading-sas7bdat-file-in-sql-managment-studio/m-p/810520#M319614 SASKiwi 2022-04-29T01:39:13Z