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;
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.