sort and merge

[RebeccaJW]

Hello,

I want to merge two datasets as shown below. 

data sub;
	set orig;
	where name="speech";
run;
data main;
	merge sub(in=a) orion.play(in=b);
	by actor;
	if a and b;
run;

If I just run the code above, there is an error saying ERROR: BY variables are not properly sorted on data set WORK.SUB.

However, if i sort the data as below:

proc sort data=sub out=sub;
	by actor;
run;

There are still errors saying  

ERROR: Insufficient space in file WORK.'SASTMP-000000713'n.UTILITY.

ERROR: File WORK.'SASTMP-000000713'n.UTILITY is damaged. I/O processing did not complete.

Can anyone help me? Thanks!

[PaigeMiller]

How big are these data sets?

[RebeccaJW]

There are almost 70000 rows and 8 columns in the data set.

[Ksharp]

Are you using SAS University Edition?

Try option TAGSORT .

proc sort data=sub out=sub  tagsort ;
	by actor;
run;