topic primary/foreign key in SAS Programming

primary/foreign key

Liliya95 — Thu, 09 Aug 2018 08:17:50 GMT

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 — Thu, 09 Aug 2018 08:45:40 GMT

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

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