Desktop productivity for business analysts and programmers

Countif equivalent

Reply
New User
Posts: 1

Countif equivalent

I have a dataset consiting of 40 rows (ResInd_1 - ResInd_40) each with a combination of one or more of the numbers 1-19.

Example

ssid  ResInd_1  ResInd_2  ResInd_3  ResInd_4  ...

1        1               1,4            4,8,10,11     2,19

2        2,3            1,5            2,6               1

...

 

I'd like to count the number of times each number occurs in total

Example

obs  occuring

1       4

2       3

3       1

...

 

Grand Advisor
Posts: 17,396

Re: Countif equivalent

Your best bet is to restructure your data using PROC TRANSPOSE and SCAN() it so that you only have one value per cell. 

Then PROC FREQ will do the counts. 

Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation