topic Re: How to create a table of baseline characteristics in Statistical Procedures

How to create a table of baseline characteristics

ChrisMac — Sat, 04 Jul 2015 10:28:56 GMT

Hi,

I want to create a table like this:

Diseases	Group 1 (also a variable)	Group 2 (also a variable)
Variable 1	Sum and percentage	Sum and percentage
Variable 2	Sum and percentage	Sum and percentage
Variable 3	Sum and percentage	Sum and percentage
Variable 4	Sum and percentage	Sum and percentage
Variable 5	Sum and percentage	Sum and percentage

Do anyone know how to to the programing? I have tried but it hasn't worked out yet.

Thanks in advance!

/Chris

Re: How to create a table of baseline characteristics

Ksharp — Sat, 04 Jul 2015 12:25:20 GMT

proc tabulate ,proc report , proc sqll all could get it. All you need is to post an example to explain it .

Re: How to create a table of baseline characteristics

ChrisMac — Sat, 04 Jul 2015 12:33:19 GMT

Hi again,

Thanks for the reply! I have a dataset with the following variables hyperlipidemi DM_type IHD_disp antal_tidl_CABG sex.

I want the table to look like this. All variables are categorial.

	sex=1	sex=0
hyperlipidemi
DM_type
IHD_disp
antal_tidl_CABG

Re: How to create a table of baseline characteristics

RW9 — Sat, 04 Jul 2015 12:48:28 GMT

Hi,

I don't mean to be standoffish, but this is something your employed to do. Much the same that I have to produce these tables as well. Its not a question requiring an answer. You can have a look at the PHUSE Wiki:

http://www.phusewiki.org/wiki/index.php?title=Standard_Script_Index

They have some example code which may help you, however you would need to follow your SOPs and coding guidelines.

Re: How to create a table of baseline characteristics

Reeza — Sat, 04 Jul 2015 13:57:40 GMT

Assuming you want what I think you want, you need the percentages and numbers in the same cell.

Based on each work environment I've found that you do need to customize each macro/report, but there are A TON of papers on Lexjansen.com that cover this.

Here's one example, starting on page 9 of the report. Good Luck.

http://www2.sas.com/proceedings/forum2008/173-2008.pdf

EDIT: Note the Resources section:

RESOURCES

You can download the programs and data in this paper from the SAS Web site for Technical Papers and Presentations for SAS Global Forum 2008 Conference at support.sas.com/rnd/papers/. Alternate versions of some of the programs are included in the downloadable zip file. These versions show more macro coding, alternate versions of the same program, or the downside of using some of the techniques in non-HTML destinations.

Re: How to create a table of baseline characteristics

Ksharp — Sun, 05 Jul 2015 04:01:02 GMT

But you didn't post some sample data yet ?