Sorting and assigning 'Sequence Number within each group' in one (minimum) steps

[DmytroYermak]

Hi all,

I have the following 

How is it possible to sort the dataset by 2 variables and assign a Sequence Number in one step?

data test;
	length division group $2.;
	infile datalines;
	input division group;
datalines;
a	t1
b	m2
a	t1
b	m2
a	t2
a	t2
a	t2
b	m2
a	t1
b	m1
b	m1
a	t2


;
run;

proc print data=test; run;

I need the following output:

[PeterClemmensen · Accepted solution]

Like this?

data test;
input division$ group$;
datalines;
a t1
b m2
a t1
b m2
a t2
a t2
a t2
b m2
a t1
b m1
b m1
a t2
;

proc sort data=test;
	by division group;
run;

data want;
	set test;
	by division group;
	Seq+1;
	if first.group then Seq=1;
run;

[DmytroYermak]

Thank you for the quick help!

[PeterClemmensen]

Anytime, glad to help 🙂

[Haikuo]

There are many ways to do the sorting in SAS, for example

proc sort data=test out=want;
by division group;
run;

Or:

proc sql;
create table want as
select * from test
order by division, group
;
quit;

Also, Hash object can also do sort, but it will be overdone for your purpose.