categorical _n_

[ilikesas]

hi,

I have a question which shouldn't be too complicated but which gives me trouble.

I have the following data:

data a;
input company $ price;
datalines;
A 1
A 2
A 4
A 5
B 2
B 4
B 7
B 9
;
run;

What I want to do is to create i = _n_ by company.

company	pric	i
A	1	1
A	2	2
A	4	3
A	5	4
B	2	1
B	4	2
B	7	3
B	9	4

and I used the code:

data a;
set a;
i = _n_;
by company;
run;

but it gave me i  = 1 to 9 and didn't notice the different companies.

Thank you!

[art297 · Accepted solution]

data a;
  set a;
  by company;
  if first.company then i=1;
  else i+1;
run;

Art, CEO, AnalystFinder.com