Skip to content
Prev 227651 / 398500 Next
Original Raw

Creating Enumerated Variables

jdellava 
Hi,

I am trying to create a variable counting the number of individuals based on
two variables. I am able to do it or one variable, but not two. In SAS I was
able to sort by two variables and use a first. statement to create the
counts based on both. Here is an example:

What I have
ID	Age		School		Grade	
1	10		1			98
2	10		2			97
3	10		1			92
4	11		1			90
5	11		1			80
6	11		2			70	
7	10		1			80	
8	10		1			79
9	11		2			70

What I need
ID	Age		School		Grade 	School Count
1	10		1			98		1
3	10		1			92		2
7	10		1			80		3
8	10		1			79		4
2	10		2			97		1
4	11		1			90		1
5	11		1			80		2
6	11		2			70		1
9	11		2			70		2

I want to create counts of individuals age 10 in school 1 then age 10 in
school two (the what I need set)

Anyway to do this?

Thank you.

Thread (7 messages)

jdellava Creating Enumerated Variables Jul 15 Wu Gong Creating Enumerated Variables Jul 15 Dennis Murphy Creating Enumerated Variables Jul 15 John Kane Creating Enumerated Variables Jul 16 Hadley Wickham Creating Enumerated Variables Jul 16 Dennis Murphy Creating Enumerated Variables Jul 16 Gabor Grothendieck Creating Enumerated Variables Jul 16