Hi there, first of all - thank you for looking at my post and for helping me organize my data. I have a sas data file with the following structure (help.have): what I need to do is to move the covariates 'phosphorus' and 'calcium' to the next month within the respective Patient ID and to set the values in month 0 equal to the baseline values. I also need to shift the outcome to the previous month and set the outcome in the last month to 'censored=a'. I need to do this in order to run an weighted regression model in the end. In the end the dataset should look like (help.want). I am using SAS 9.4. I am not sure with what approach to go about this, so I haven't tried anything yet. Thanks a lot for your inputs - any ideas are welcome. data help.have;
infile datalines dsd truncover;
input PatID exposure month phosphate calcium phos_baseline calc_baseline outcome;
datalines4;
1,2,0,2.5,13,2.6,14,0,
1,2,1,2.7,11,2.6,14,0,
1,2,2,2.6,10,2.6,14,0,
1,2,3,2.4,10,2.6,14,0,
2,1,0,2.2,11,2.5,12,0,
2,1,1,2.1,10,2.5,12,0,
2,1,2,2.0,9.5,2.5,12,1,
3,2,0,2.8,12,2.2,9,0,
3,2,1,2.7,11,2.2,9,0,
3,2,2,2.9,12,2.2,9,0,
3,2,3,3.0,10,2.2,9,0
;;;; data help.want;
infile datalines dsd truncover;
input PatID exposure month phosphate calcium outcome;
datalines4;
1,2,0,2.6,14,2.6,14,0
1,2,1,2.5,13,2.6,14,0
1,2,2,2.7,11,2.6,14,0
1,2,3,2.6,10,2.6,14,0
2,1,0,2.5,12,2.5,12,0
2,1,1,2.2,11,2.5,12,1
2,1,2,2.1,10,2.5,12,a
3,2,0,2.2,9,2.2,9,0
3,2,1,2.8,12,2.2,9,0
3,2,2,2.7,11,2.2,9,0
3,2,3,2.9,12,0
;;
... View more