topic Re: How to combine multiple variables to create a new single variable? in SAS Programming

How to combine multiple variables to create a new single variable?

Rou — Fri, 01 Jul 2022 01:52:05 GMT

Bellow is what I used to create a new variable but I am getting an error when I run my ttest:

data mergeddata;

set mergedfinal-fmt;
var1 = 'promis_pa_scale1';
var2 = 'promis_pa_scale3';
var3 = 'promis_pa_scale4';
var4 = 'promis_pa_scale5';
length pascale $ 69;
pascale = catx(',', var1, var2, var3, var4);
put _all_;
run;

data mergeddata;

set mergedfinal_fmt;
var1 = 'promis_pa_scale1_fu';
var2 = 'promis_pa_scale3_fu';
var3 = 'promis_pa_scale4_fu';
var4 = 'promis_pa_scale5_fu';
length pascale_fu $ 79;
pascale_fu = catx(',', var1, var2, var3, var4);
put _all_;
run;

proc ttest data= mergeddata;
paired pascale*pascale_fu;
run;

Re: How to combine multiple variables to create a new single variable?

Tom — Fri, 01 Jul 2022 01:59:25 GMT

You need to show the log for the step with the error.

You cannot run a TTEST on a character variable.

Re: How to combine multiple variables to create a new single variable?

Rou — Wed, 06 Jul 2022 02:37:39 GMT

I figured out my mistake, here's what i did.

data finalaverage;
set mergedfinal;
intervention= (promis_pa_scale1 + promis_pa_scale3 + promis_pa_scale4 + promis_pa_scale5)/4;
comparison= (promis_pa_scale1_fu + promis_pa_scale3_fu + promis_pa_scale4_fu + promis_pa_scale5_fu)/4;
run;

data promispa;
set finalaverage;
diff= (intervention/comparison)+ 1;
run;

proc ttest data= promispa;
paired intervention*comparison;
run;

Re: How to combine multiple variables to create a new single variable?

mkeintz — Wed, 06 Jul 2022 04:22:23 GMT

@Rou wrote:

I figured out my mistake, here's what i did.

Great. Mark your own response as the solution, so that other will see this listed as a solved topic.