About cmahrb2

cmahrb2 · ‎11-20-2015

Each time a person has a new drug, they are on a new line. So a person could have 10 of drug A, two of drug B and 1 of drug C for a total of 13 lines for this person. So there is the challenge. Each line has a indicator of which drug it is, but it is more complex than just one array per person.

cmahrb2 · ‎11-19-2015

My data currently has multiple rows per person, and each of these rows contain an array that looks at whether or not the person was on a drug from 1-365. There are three different array's per person(A,B,C) since there are three classes of drugs that I am looking at. I want to be able to see when one person is taking all three of them at the same time, and get a count of how many times it happends for the entire year. example: IF A[112]='1' and B[112]= '1' and C[112]='1' then overlap_count=(1) since these are all on seperate rows I would need the count to work on a key level and have the overlap_count displayed on each of the rows.

cmahrb2 · ‎10-29-2015

What would you like to know ?

cmahrb2 · ‎10-29-2015

I am trying to calculate the dosage of a particular drug for a population to see if any member in this population is over a certain threshold for any 90 consecutive days. So to do this I am thinking that I am going to need to make a arraty that looks at the strengh of this drug over 90 days from an index and if they are all '1' then they get a 'pass', and somehow put this into a do loop to look at all of the potential 90 day windows for a year i=1...i=275 to see if a member at any point during the year has met the criteria. Thoughts?

Online Status	Offline
Date Last Visited	‎11-24-2015 09:38 AM

Re: Counting across multiple Rows

Counting across multiple Rows

Re: How to create rolling arrays in SAS

How to create rolling arrays in SAS

Re: Counting across multiple Rows

Re: Counting across multiple Rows

Counting across multiple Rows

Re: How to create rolling arrays in SAS

How to create rolling arrays in SAS