how to get sql server schema data in to sas for automation purpose

[jayasubbareddy]

how to get sql server  schema data into sas for automation purpose

[Patrick]

@jayasubbareddy 

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.

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?

[andreas_lds]

What exactly do you want to automate?

Are the tables registered in sas metadata? If yes, you can query sashelp.vcolumns to get the tables metadata.

[jayasubbareddy]

libname cdm odbc uid= pwd= dsn=cdm schema=dbo

in this i have access but i have data in another schemas like payments_aru  and resposnsys,

[Patrick]

@jayasubbareddy 

Then define another libname with this schema.

[jayasubbareddy]

its getting error

[Reeza]

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.

[Patrick]

@andreas_lds 

You don't need to register the tables in SAS Metadata unless you use the META engine in the libname statement.

[andreas_lds]

---

@Patrick wrote:

@andreas_lds 

You don't need to register the tables in SAS Metadata unless you use the META engine in the libname statement.

---

Of course not, but it makes using data (and the metadata) somewhat easier, while new to sas.

[Patrick]

@andreas_lds 

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.