topic Proc tabulate enquiry in New SAS User

Proc tabulate enquiry

jlin4 — Thu, 14 Jan 2021 16:14:38 GMT

Hi, I would like to seek some advice regarding proc tabulate. Using the heart dataset as an example, say that for whatever reason, I am interested in finding out the value of 2*mean of systolic of each group (systolic is a continuous variable) after classifying each row in the dataset according to 2 categorical columns (sex and weight_status). The codes below are wrong, but is there an elegant way to do such tabulation using proc tabulate? Or generally, is there a way to customise more complex computations using systolic, apart from computing its mean, median, min, max, etc. Thank you!

proc tabulate data=sashelp.heart;
	class sex weight_status;
	var systolic;
	table sex, weight_status*systolic*(mean*2);
run;

Re: Proc tabulate enquiry

PhilC — Thu, 14 Jan 2021 19:25:52 GMT

The asterisk symbol used in the TABLES statement does not denote multiplication. That's probably one of the more difficult hurdles one has to leap when learning this.

ods select none;
proc tabulate data=sashelp.heart 
              out =have(drop=_:);
	class sex weight_status;
	var systolic;
	table sex, weight_status*systolic*(mean) /;
run;
ods select all;

data want;
 set have;
 double_Systolic_Mean=2*Systolic_Mean;
run;

Re: Proc tabulate enquiry

ballardw — Thu, 14 Jan 2021 22:08:25 GMT

For this type of problem the approach would be:

1) summarize the data by the desired groups to get the mean for the groups (Proc summary is easy)

2) use a data step to multiply that mean by 2 for each group

3) Print or Proc Report to display the values.

Proc Tabulate does not let you calculations internally with the resulting statistics or cross statistics.