DATA Step, Macro, Functions and more

categorical _n_

Accepted Solution Solved
Reply
Super Contributor
Posts: 413
Accepted Solution

categorical _n_

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!


Accepted Solutions
Solution
‎03-22-2017 02:16 PM
PROC Star
Posts: 7,365

Re: categorical _n_

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

Art, CEO, AnalystFinder.com

View solution in original post


All Replies
Solution
‎03-22-2017 02:16 PM
PROC Star
Posts: 7,365

Re: categorical _n_

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

Art, CEO, AnalystFinder.com

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 107 views
  • 0 likes
  • 2 in conversation