Hi all,  i have a dataset with one oberservation for each id. I want to compare values between two variables using paired t-test.  My problem is, that i have a lot of missings in one of the variables and when i do the proc t-test, sas only uses a small number of observations. Is there a way, where i can compare means calculated using all the observations in each variable? ... View more

Hi all. I have a dataset containing several observations for each study participant. In each row, i have a variable indicating whether the blood pressure is within a target. I also have a varible indicating whether blood pressure is above the target.   For study participants whose blood pressure remain within the target all observation (e.g. the participant have no observation with indication of the blood pressure being above), i want to know how many times the participant have values within the target and at what date the patient was in the target for the first time.  The date is in the format date9.    data have; input id date target above_target; datalines; 1 24MAY2015 0 0 1 25MAY2015 0 1 1 26MAY2015 1 0 2 01JAN2016 1 0 2 02JAN2016 0 0 2 03JAN2016 1 0 3 27MAR2015 0 0 3 28MAR2015 0 0 4 26JUN2016 0 1  4 27JUN206 0 1 ;   data want; input id date_first_target number_target; datalines; 1 . . 0 2 01JAN2016 2 3 . . 0 4 . . 0 ;   I hope you can help me, thanks 🙂 ... View more

Hi All, I want to calculate the mean of blood pressures in my dataset. I have a variables for each blood pressure (bp1, bp2,bp3 etc). It is variable how many blood pressure each participant have (they can have up to 20 or more).    data have; input ID bp1 bp2 bp 3; datalines; 1 145 120 125 2 130 . .  3 125 125 ; run;   data want; input ID bp1 bp2 bp3 mean; datalines; 1 145 120 125 130 2 130 . . 130 3 125 125 125 ; run; ... View more

Hi All,  I am working with a dataset containing information about dates of bloodsamples in a cohort of women who have been pregnant one or more times. I need to calculate parity of the woman at sampling point.    data have; input woman_id date_of_delivery woman_birth_date sampling date; datalines; 1 21-dec-2001 01-jan-1971 12-jun-2020 1 01-jan-2003 01-jan-1971 12-jun-2020 1 07-aug-2005 01-jan-1971 12-jun-2020 1 13-jun-2009 01-jan-1971 12-jun-2020 2 07-Jan-2010 15-APR-1970 10-may-2009 2 07-Jan-2010 15-APR-1970 12-may-2021 2 07-Jan-2010 15-APR-1970 14-may-2021 3 26-jan-1980 07-aug-1961 18-jan-1979 3 26-jan-1980 07-aug-1961 20-jan-1979 3 26-jan-1980 07-aug-1961 14-mar-2021 3 26-jan-1980 07-aug-1961 17-mar-2021 3 10-aug-1983 07-aug-1961 18-jan-1979 3 10-aug-1983 07-aug-1961 20-jan-1979 3 10-aug-1983 07-aug-1961 14-mar-2021 3 10-aug-1983 07-aug-1961 17-mar-2021 3 12-sep-1985 07-aug-1961 18-jan-1979 3 12-sep-1985 07-aug-1961 20-jan-1979 3 12-sep-1985 07-aug-1961 14-mar-2021 3 12-sep-1985 07-aug-1961 17-mar-2021 ; run; data WANT; input woman_id date_of_delivery woman_birth_date sampling date parity; datalines; 1 21-dec-200101-jan-1971 12-jun-2020 4 1 01-jan-2003 01-jan-1971 12-jun-2020 4 1 07-aug-2005 01-jan-1971 12-jun-2020 4 1 13-jun-2009 01-jan-1971 12-jun-2020 4 2 07-Jan-2010 15-APR-1970 10-may-2009 0 2 07-Jan-2010 15-APR-1970 12-may-2021 1 2 07-Jan-2010 15-APR-1970 14-may-2021 1 3 26-jan-1980 07-aug-1961 18-jan-1979 0 3 26-jan-1980 07-aug-1961 20-jan-1979 0 3 26-jan-1980 07-aug-1961 14-mar-2021 4 3 26-jan-1980 07-aug-1961 17-mar-2021 4 3 10-aug-1983 07-aug-1961 18-jan-1979 0 3 10-aug-1983 07-aug-1961 20-jan-1979 0 3 10-aug-1983 07-aug-1961 14-mar-2021 4 3 10-aug-1983 07-aug-1961 17-mar-2021 4 3 12-sep-1985 07-aug-1961 18-jan-1979 0 3 12-sep-1985 07-aug-1961 20-jan-1979 0 3 12-sep-1985 07-aug-1961 14-mar-2021 4 3 12-sep-1985 07-aug-1961 17-mar-2021 4 ; run; ... View more

Hello all,  i am creating a really simple sgplot, where i want to use an xaxistable. My problem is, that the xaxistable is not aligned with the x-axis. It shows too many observations.  How can i get the values to align with the values on the x-axis?   example data: data have; input time count cumulative_percent; datalines; 1 4 10 2 10 25 3 2 5 4 20 50 5 4 10 ; run; proc sgplot data = abc; series x=time y = count; taxis values = 0 to 52 by 5); xaxistable cumulative_percent;run;   ... View more

Hello all,  I am doing a survival curve using proc sgplot and the group statement. I have a total of 8 groups. I need some of the groups to have dotted lines and some of them to have full lines and specify every groups colour.  How to put it into the following code?   proc sgplot data=abc2; series x=weeks y=SURVIVAL1 /group = exp_event; run;     ... View more