topic Re: List columns names contained in a db in SAS Programming

List columns names contained in a db

Tecla1 — Thu, 15 Oct 2020 13:08:46 GMT

Good Afternoon,

I often need to go into DB to check the right name of column …. there is a data that show alla names of columns?

I read more document but i have not find a right refer.

Many thnks for your kindly help.

Tecla

andreas_lds — Thu, 15 Oct 2020 13:13:05 GMT

Depends on the sas-tool you are using and the way you access the db.

If you are using EG 8.x and a library is assigned to the db, you can use the drill down to the variable names using the library-view.

Tecla1 — Thu, 15 Oct 2020 13:23:10 GMT

Tnks Andreas, I need to put column names in a new DB line by line.

Kurt_Bremser — Thu, 15 Oct 2020 13:52:52 GMT

When a SAS library for the remote DB schema is defined, the columns should appear in DICTIONARY.COLUMNS in PROC SQL.