paired t test

[starz4ever2007]

can you put "where" syntax in proc ttest?

I essentially want to do a paired t test between _1_sbt_total (where v2_dlqi_total = '1')  and _16_sbt_total (where v5_dlqi_total = '1')

_sbt_total variables are continuous and dlqi_total variables I have it formatted it to be categorical

proc format;

value v2_dlqi_total low-5 = '1' 6-high ='2';

value v5_dlqi_total low-5 = '1' 6-high ='2';

proc ttest data=work.data (where = (include=1 ));
paired ( _1_sbt_total where v2_dlqi_total = '1') * ( _16_sbt_total where v5_dlqi_total = '1');
format v2_dlqi_total v2_dlqi_total. v5_dlqi_total v5_dlqi_total.;
run;

[PGStats · Accepted solution]

No.

Your first use of WHERE as a dataset option is correct.

But the values to be paired ( _1_sbt_total,  _16_sbt_total) must reside in the same observation. You will need to reorganize your data.