I have to assign numbers to groups in two ways. First I was able to achieve(pt_id). The other one, I want to assign the same number to each soc, so in this case, soc1 will have value 1 for all first 3 rows. And soc 2 will have value of 2. data in; input soc $ pt $; datalines ; soc1 pt1 soc1 pt2 soc1 pt8 soc2 pt1 ; run; data out; set in; by soc pt; if first.soc then pt_id=0; pt_id+1; run; output, should look like this... soc pt pt_id soc_id ____________________ soc1 pt1 1 1 soc1 pt2 2 1 soc1 pt8 3 1 soc2 pt1 1 2 What I should add in the datastep to get he soc_id. Thank you!
... View more