Foreign Key problems

[tomcmacdonald]

I can't make this code work

proc sql;
  create table foo (
    id char(11)
  );

  create table bar (
    id char(11)
  );

quit;


proc datasets lib=work;

	modify foo;
		ic create primary key(id);
	modify bar;
		ic create primary key(id);
		ic create fkey = foreign key(id) references foo;

run;

I'm getting the following errors:

ERROR: An index named id with the same definition but different characteristics exists for file WORK.BAR.DATA.

[Patrick]

Please post the same question only once.

Answer here: 

https://communities.sas.com/t5/Base-SAS-Programming/Defining-a-foreign-key-on-a-table-in-PROC-SQL-th...