I have a policy level data set where each policy can have multiple riders and each rider has unique code. Now I want to count how many policies have a specific rider code (R001), this code can be under columns Rider1, Rider2 and Rider3. I am not able to figure out how to do this with this using SAS.
Any help would be appreciated!!
Pol_ID Rider1 Rider2 Rider3 P001 R002 R001 R002 P002 R001 R001 R003 P003 R002 R003 R001 P004 R001 R001 R001