topic Re: Calculation of Baseline values in SAS Programming

Calculation of Baseline values

Aidaan_10 — Mon, 07 May 2018 16:45:29 GMT

Hi All,

I have to calculate baseline for two different visits for which I used this step

proc tabulate data= data2a out=baseline (drop=_:);
where visit in('Period1' 'Period2');
class tests visit;
var aval;
table tests*visit*aval* ( mean);
run;

My dataset baseline would be something like this:

Tests Visit Aval_Mean

ABC Period1 12345

ABC Period2 67890

DEF Period1 56789

DEF Period2 93489

And I have the AVAL_MEAN value for two different visits , so now when I merge this baseline data with post baseline visits by tests the AVAL_MEAN from period1 Values are getting overwritten by period2 values for postbaseline visits something like this:

Tests Visit Aval_Mean

ABC Period1 12345

ABC Period1_day3 67890

ABC Period1_day4 67890

ABC Period2 67890

ABC Period2_day3 67890

ABC Period2_day4 67890

but I dont need this and I need something like this:

Tests Visit Aval_Mean

ABC Period1 12345

ABC Period1_day3 12345

ABC Period1_day4 12345

ABC Period2 67890

ABC Period2_day3 67890

ABC Period2_day4 67890

Can someone please suggest me a workaround for this...Any help will be greatly appreciated...Thanks

Re: Calculation of Baseline values

ballardw — Mon, 07 May 2018 17:56:09 GMT

Show how you are combining the data sets.

It sounds like you are using merge and have a same named variable in both sets. The order of the sets in merge determines which value is kept with same named variables. Perhaps you need to rename a variable. But without a better example of both data sets it isn't clear.

Re: Calculation of Baseline values

Aidaan_10 — Mon, 07 May 2018 18:01:37 GMT

I am merging them by tests..

data data4;
merge baseline data3;
by tests ;

run;

If I use visit in the by statement then I am getting the aval_mean value just for the the period1 and period2 visits and missing for postbaseline visits...

Re: Calculation of Baseline values

Aidaan_10 — Mon, 07 May 2018 18:05:18 GMT

And also I would like to add something here...which I missed the visits for baseline are 'Period1_day-1' 'Period2_day-2' and not just Period1' 'Period2' .