topic sort and merge in SAS Studio

sort and merge

RebeccaJW — Mon, 15 Apr 2019 18:57:01 GMT

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 — Mon, 15 Apr 2019 19:03:51 GMT

How big are these data sets?

RebeccaJW — Mon, 15 Apr 2019 19:55:13 GMT

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

Ksharp — Tue, 16 Apr 2019 13:17:39 GMT

Are you using SAS University Edition?

Try option TAGSORT .

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