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"
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
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.
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;
Definitely a couple of questions in order to get started ...
proc means data = epilepsy n mean; Var Age rate; run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.