Proc Tabulate Question

[A_Halps]

Hi! I am trying to recreate a current table I have into the format that proc tabulate creates, but it's not working out correctly. I'm not sure where I am currently going wrong.

I have an outputted table that looks like this:

date	taking_meds	count
1/1	0	500
1/1	1	100
1/2	0	46
1/2	1	94
1/3	0	455
1/3	1	12
1/4	0	224
1/4	1	81

When I do proc_tabulate, I get the following table:

It should look like this though:

Here is my code:

proc sql;
create table meds as
select distinct date, taking_meds, count(*) as count
from (select * from t_meds where date ne "")
group by date, taking_meds;
quit;

proc tabulate data = meds;
class date taking_meds;
tables date, taking_meds* (N rowpctn) all;
run;

Thanks!

[yabwon · Accepted solution]

you need to specify FREQuency:

data  meds;
input date $ taking_meds count;
cards;
1/1	0	500
1/1	1	100
1/2	0	46
1/2	1	94
1/3	0	455
1/3	1	12
1/4	0	224
1/4	1	81
;
run;

proc tabulate data = meds;
  class date taking_meds;
  FREQ count;
  tables date, taking_meds * (N rowpctn) all*N;
run;

Bart

[A_Halps]

Thank you!!!