Defining a primary key on a table in PROC SQ

[pepevo]

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.

[Tom · Accepted solution]

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.