primary/foreign key

[Liliya95]

Whether it is possible to write down the request for creation of a temporary table with instructions of external and internal key?

for example,

% macro test;


 data(keep one two three);


length one $50 two $50 three 8;


%mend test;

 I need to specify that one is the primary key. Can this be done?

[RW9]

Primary keys come from the database world, they are not a SAS thing.  Two different technologies!  You can fake it with:

https://communities.sas.com/t5/Base-SAS-Programming/Primary-key/td-p/456421

@s_lassen

However why?  Start thinking SAS if your going to use SAS, its different technology to databases.