Programming the statistical procedures from SAS

Summing over the column

Reply
Occasional Contributor
Posts: 16

Summing over the column

I have a data set like as follows

PatientID  year  adherence

1               1        0

1               2       1

1               3       1

2               1       1

2               2      1

3               1       1

3               2       1

3               3       0

3               4       1  

What i want is to create a new variable that will give cumulative adherence at year "i". Thus the data with a new variable will look like

PatientID  year    adherence  cumulativeAdherence

1              1           0               0

1              2           1               1

1              3           1               2

2              1           1               1

2              2           1               2

3              1           1              1

3              2           1              2

3              3           0              2

3              4           1              3

PROC Star
Posts: 7,417

Summing over the column

Couldn't you just use something like:

data want;

   set have;

   by PatientID;

   if first.PatientID then cumulativeAdherence=adherence;

   else cumulativeAdherence+adherence;

run;

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