topic Re: Two table statements in PROC Tabulate due to different statistics and we want merge them into on in SAS Programming

Two table statements in PROC Tabulate due to different statistics and we want merge them into one

TomHsiung — Sun, 04 May 2025 19:18:02 GMT

We use different statistics for continuous and category variables, respectively. We have to use two table statement. Is there any way to show them in one table? Thanks.

Code:

proc tabulate data = d202_raw;
title 'Summary of patient characterisitcs';
class AF gender smoker CHF DM Stroke Hypertension HFstage hypoalbuminemia RIFLE
indication1 CYP2C9 VKORC1
Amiodarone Statin Antiplatelets
;
var ageY wt bsa followUp
alb1 alb2 alb3 alb4 alb5
;
table
ageY
wt
bsa
followUp
alb1
alb2
alb3
alb4
alb5
, AF = 'Atrial fibrillation' * (N Mean STD Q1 Q3)
all = 'Overall' * (N Mean STD Q1 Q3);
table
gender
smoker
CHF
DM
Stroke
Hypertension
HFstage
hypoalbuminemia
RIFLE
indication1
CYP2C9
VKORC1
Amiodarone
Statin
Antiplatelets
, AF = 'Atrial fibrillation' * (N colpctn = '%')
all = 'Overall' * (N colpctn = '%')
;
run;

Re: Two table statements in PROC Tabulate due to different statistics and we want merge them into on

mkeintz — Sun, 04 May 2025 20:36:10 GMT

You want to know if you can form a table statement that generates one set of statistics for some rows (class vars) and other statistics for other rows (continuous vars).

The answer is no.

But the greater question is why? Are you trying to generate a specific sequence of variables in your report?

Re: Two table statements in PROC Tabulate due to different statistics and we want merge them into on

Cynthia_sas — Sun, 04 May 2025 21:56:41 GMT

Hi:
This looks like the type of demographic table that is typically generated either with a DATA step or with PROC REPORT. There have been many previous forums postings about how to generate this type of table. And, a lot of user group papers, too. If you search on www.lexjansen.com for "demographic tables" you will find a variety of papers on the topic.
Cynthia

Re: Two table statements in PROC Tabulate due to different statistics and we want merge them into on

TomHsiung — Mon, 05 May 2025 02:34:49 GMT

Hello, Cynthia

Thank you very much and now I am enjoying the %TABLEN macro, which is perfect for the demographic table generation.

Have a nice day!

https://www.lexjansen.com/pharmasug/2020/AD/PharmaSUG-2020-AD-088.pdf

Re: Two table statements in PROC Tabulate due to different statistics and we want merge them into on

TomHsiung — Mon, 05 May 2025 02:35:24 GMT

Thanks for the response and I solved the issue by %TABLEN macro.