Defining a primary key on a table in PROC SQ

pepevo — Thu, 06 Jun 2019 13:11:26 GMT

Hello Experts,

How can I defining a primary key on a table in PROC SQL? Under "My Libraries" I choose a table's columns, all I see a property and value. How can I defining the primary and/or foreign key of a table.

Describe table table_name gives me nothing but columns' property and value.

I tried describe table constraints table_name and it said table_name does not have any integrity constraints to describe. Which meant it doesn't have primary/foreign key, right?

thank you.

Re: Defining a primary key on a table in PROC SQ

Tom — Thu, 06 Jun 2019 13:22:56 GMT

SAS is not a database system. So you do not need to define primary or foreign keys.

For clues as to what variables might be considered the unique identifiers for a dataset you could look at the SORTED BY attribute. Or see if any INDEXes have been created.

Otherwise refer to any documentation that you have received along with the data.

topic Defining a primary key on a table in PROC SQ in SAS Studio

Defining a primary key on a table in PROC SQ

Re: Defining a primary key on a table in PROC SQ