BookmarkSubscribeRSS Feed
Statsconsultancy
Fluorite | Level 6

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

1 REPLY 1
art297
Opal | Level 21

Couldn't you just use something like:

data want;

   set have;

   by PatientID;

   if first.PatientID then cumulativeAdherence=adherence;

   else cumulativeAdherence+adherence;

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1373 views
  • 0 likes
  • 2 in conversation