https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553266#M153834 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/15475">@andreas_lds</a>&nbsp;</P> <P>Let's agree to disagree. I tend to think that the concept of SAS Metadata is for "Base SAS users" 2nd level and most of the time only of importance for BI/DIS applications - or if using Metadata security.&nbsp;</P> Tue, 23 Apr 2019 14:10:57 GMT Patrick 2019-04-23T14:10:57Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553216#M153812 <P>how to get sql server&nbsp; schema data into sas for automation purpose</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Apr 2019 13:10:22 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553216#M153812 jayasubbareddy 2019-04-23T13:10:22Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553220#M153815 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/267681">@jayasubbareddy</a>&nbsp;</P> <P>SAS provides access modules to interface with data bases (like SAS Access to SQL Server or SAS Access to ODBC). If you've got one of these access modules licensed and installed then it's just a question of configuration to access a SQL Server database.</P> <P>Can you provide a bit more detail? Where are you at right now? Do you have the required SAS modules licensed? Do you already have a working connection to the database? Can you "see" any of the tables?</P> Tue, 23 Apr 2019 13:15:58 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553220#M153815 Patrick 2019-04-23T13:15:58Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553225#M153816 <P>What exactly do you want to automate?</P> <P>&nbsp;</P> <P>Are the tables registered in sas metadata? If yes, you can query sashelp.vcolumns to get the tables metadata.</P> Tue, 23 Apr 2019 13:19:33 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553225#M153816 andreas_lds 2019-04-23T13:19:33Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553233#M153822 <P>libname cdm odbc uid= pwd= dsn=cdm schema=dbo</P><P>in this i have access but i have data in another schemas like payments_aru&nbsp; and resposnsys,</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Apr 2019 13:28:02 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553233#M153822 jayasubbareddy 2019-04-23T13:28:02Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553234#M153823 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/15475">@andreas_lds</a>&nbsp;</P> <P>You don't need to register the tables in SAS Metadata unless you use the META engine in the libname statement.</P> Tue, 23 Apr 2019 13:31:35 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553234#M153823 Patrick 2019-04-23T13:31:35Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553238#M153825 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/267681">@jayasubbareddy</a>&nbsp;</P> <P>Then define another libname with this schema.</P> Tue, 23 Apr 2019 13:32:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553238#M153825 Patrick 2019-04-23T13:32:51Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553264#M153833 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447">@Patrick</a>&nbsp;wrote:<BR /> <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/15475">@andreas_lds</a>&nbsp;</P> <P>You don't need to register the tables in SAS Metadata unless you use the META engine in the libname statement.</P> <HR /></BLOCKQUOTE> <P>Of course not, but it makes using data (and the metadata) somewhat easier, while new to sas.</P> Tue, 23 Apr 2019 14:06:13 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553264#M153833 andreas_lds 2019-04-23T14:06:13Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553266#M153834 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/15475">@andreas_lds</a>&nbsp;</P> <P>Let's agree to disagree. I tend to think that the concept of SAS Metadata is for "Base SAS users" 2nd level and most of the time only of importance for BI/DIS applications - or if using Metadata security.&nbsp;</P> Tue, 23 Apr 2019 14:10:57 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553266#M153834 Patrick 2019-04-23T14:10:57Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553271#M153837 <P>its getting error</P> Tue, 23 Apr 2019 14:19:26 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553271#M153837 jayasubbareddy 2019-04-23T14:19:26Z https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553284#M153845 It would help if you post significantly more details. We don't have enough information to help you otherwise. For starters, show the code you're trying and the error you're getting. Tue, 23 Apr 2019 14:47:44 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-sql-server-schema-data-in-to-sas-for-automation/m-p/553284#M153845 Reeza 2019-04-23T14:47:44Z