Table 1 problems

[Morten Hans Jensen]

Hi Statalist

I want to make a baseline demographic table (table 1) but I am having some problems.
I have an unexposed and an exposed group with this distribution:

| exposed
unexposed | 1 . | Total
----------------+---------------------------+---
1 | 12,032 4,632 | 16,664
. | 5,003 0 | 5,003
--------------+------------------+----------
Total | 17,035 4,632 | 21,667

	Exposed	Total
Unexposed	1 .
1	12,032 4,632	16,664
.	5,003 0	5,003
Total	17,035 4,632	21,667

I would like a table that has:

	Unexposed	Exposed	Total
Sex - female - male
Ethinicity - -
....
...

My problem is that some of the unexposed will become exposed at some point and I therefore have two different variables for unexposed and exposed. When i try to make a table it looks like this:

This is a bit off from what I want. Any suggestions?

[Morten Hans Jensen]

Any help would be appreciated.

[Rich Goldstein]

see Chuck Huber's 7 part blog on the -table- command, esp. part 3 which discusses these types of tables in some detail

[Rich Goldstein]

I forgot to include the url above: https://blog.stata.com/2021/06/24/cu...assic-table-1/

[Morten Hans Jensen]

Hi Rich

Thank you for the reply. I can however not see if it solve my problem. My problem is shown in the screenshot I put in. The exposed and unexposed groups have a significant overlap in people which gives some weird tables when I try to make one. I want an exposed and an unexposed group.