categorical _n_

ilikesas — Wed, 22 Mar 2017 18:08:58 GMT

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.

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!

Re: categorical _n_

art297 — Wed, 22 Mar 2017 18:12:52 GMT

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

Art, CEO, AnalystFinder.com