How to Create one table displaying average age and weekly seizure rate at baseline by treatment

[Stacy]

Question is to Create one table displaying average age and weekly seizure rate at baseline by treatment .

proc means data = epilepsy n mean;
Var Age;
title "AverageAge";
proc tabulate data = epilepsy;
var seizurecount Age; 
table seizurecount*Age;
run;

This is my code. The error it gave is that "There are multiple analysis variables associated with a single table cell in the following
nesting : Seizurecount * Age"

[PeterClemmensen]

Can you show us what your data looks like? Sounds like a single procedure job and not something you need both PROC MEANS and PROC TABULATE to do

[Stacy]

I added a picture of my data.

[PeterClemmensen]

I don't see any picture. Also, a picture is not the best way to post data. Post your example data in the form of a data step or insert a table.

You can use this macro to create a data step version of your SAS data set. 

[Stacy]

data epilepsy;
  infile datalines truncover;
  input ID $ Treatment Age @;
  do period = 0 to 4;
    if period = 0 then weeks = 8;
	else weeks = 2;
    input Seizurecount @;
	rate = Seizurecount / weeks;
    output;
  end;
  datalines;
1     0      31      11      5     3     3     3
2     0      30      11      3     5     3     3
3     0      25       6      2     4     0     5
4     0      36       8      4     4     1     4
5     0      22      66      7    18     9    21
6     0      29      27      5     2     8     7
7     0      31      12      6     4     0     2
8     0      36      52     40    20    23    12
9     0      37      23      5     6     6     5
10     0      28      10     14    13     6     0
11     0      36      52     26    12     6    22
12     0      24      33     12     6     8     5
13     0      28      18      4     4     6     2
14     0      36      42      7     9    12    14
15     0      26      87     16    24    10     9
16     0      26      50     11     0     0     5
17     0      28      18      0     0     3     3
18     0      31     111     37    29    28    29
19     0      32      18      3     5     2     5
20     0      21      20      3     0     6     7
21     0      29      12      3     4     3     4
22     0      21       9      3     4     3     4
23     0      32      17      2     3     3     5
24     0      25      28      8    12     2     8
25     0      30      55     18    24    76    25
26     0      40       9      2     1     2     1
27     0      19      10      3     1     4     2
28     0      22      47     13    15    13    12
29     1      18      76     11    14     9     8
30     1      32      38      8     7     9     4
31     1      20      19      0     4     3     0
32     1      20      10      3     6     1     3
33     1      18      19      2     6     7     4
34     1      24      24      4     3     1     3
35     1      30      31     22    17    19    16
36     1      35      14      5     4     7     4
37     1      57      11      2     4     0     4
38     1      20      67      3     7     7     7
39     1      22      41      4    18     2     5
40     1      28       7      2     1     1     0
41     1      23      22      0     2     4     0
42     1      40      13      5     4     0     3
43     1      43      46     11    14    25    15
44     1      21      36     10     5     3     8
45     1      35      38     19     7     6     7
46     1      25       7      1     1     2     4
47     1      26      36      6    10     8     8
48     1      25      11      2     1     0     0
49     1      22     151    102    65    72    63
50     1      32      22      4     3     2     4
51     1      25      42      8     6     5     7
52     1      35      32      1     3     1     5
53     1      21      56     18    11    28    13
54     1      41      24      6     3     4     0
55     1      32      16      3     5     4     3
56     1      26      22      1    23    19     8
57     1      21      25      2     3     0     1
58     1      36      13      0     0     0     0
59     1      37      12      1     4     3     2
;
run;

[Astounding]

Definitely a couple of questions in order to get started ...

• Your data set already contains RATE.  Is there any reason you still need SEIZURECOUNT for this report?
• How do you determine which records are "at baseline" ? 
• Could this be as simple as the program  below, or is there more to it?

proc means data = epilepsy n mean;
Var Age rate;
run;