BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
YK5
Calcite | Level 5 YK5
Calcite | Level 5

Hi there, 

Does anyone know how to compare a variable between 2 different datasets in SAS, please? I would like to assess whether there is a statistically significant difference in median age between 2 different datasets. 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Combine the data sets into one, with the variable and indicate the source.

 

data combined;
set ds1 (keep=age) ds2(keep=age) indsname = source;

data_source = source;
run;

proc npar1way data =combined wilcoxon median;
class data_source;
var age;
run;

Reference: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_npar1way_examples01....

 


@YK5 wrote:

Hi there, 

Does anyone know how to compare a variable between 2 different datasets in SAS, please? I would like to assess whether there is a statistically significant difference in median age between 2 different datasets. 


 

View solution in original post

2 REPLIES 2
Reeza
Super User

Combine the data sets into one, with the variable and indicate the source.

 

data combined;
set ds1 (keep=age) ds2(keep=age) indsname = source;

data_source = source;
run;

proc npar1way data =combined wilcoxon median;
class data_source;
var age;
run;

Reference: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_npar1way_examples01....

 


@YK5 wrote:

Hi there, 

Does anyone know how to compare a variable between 2 different datasets in SAS, please? I would like to assess whether there is a statistically significant difference in median age between 2 different datasets. 


 

YK5
Calcite | Level 5 YK5
Calcite | Level 5
That is wonderful, thank you so much for your help!

SAS Innovate 2025: Register Today!

 

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 532 views
  • 1 like
  • 2 in conversation