Count by Variable Groups

[thb]

Hello,

I have the following table:

ID	Date	Rating
1	Jan-14	High
1	Feb-14	High
1	Mar-14	Low
2	Jan-14	Low
2	Feb-14	Low
3	Jan-14	High
3	Feb-14	High
4	Jan-14	Low
4	Feb-14	Low
4	Mar-14	High
4	Apr-14	High
5	Jan-14	Low

I am trying to create a count of the Ratings by Month to create the following table:

	Jan-14	Feb-14	Mar-14	Apr-14	Total
High	2	2	1	1	6
Low	2	2	1	0	5
Total	4	4	2	1	11

Any help would be greatly appreciated.

Thank you in advance.

[Reeza]

Have you tried PROC FREQ?

---

@thb wrote:

Hello,

I have the following table:

ID	Date	Rating
1	Jan-14	High
1	Feb-14	High
1	Mar-14	Low
2	Jan-14	Low
2	Feb-14	Low
3	Jan-14	High
3	Feb-14	High
4	Jan-14	Low
4	Feb-14	Low
4	Mar-14	High
4	Apr-14	High
5	Jan-14	Low

I am trying to create a count of the Ratings by Month to create the following table:

	Jan-14	Feb-14	Mar-14	Apr-14	Total
High	2	2	1	1	6
Low	2	2	1	0	5
Total	4	4	2	1	11

Any help would be greatly appreciated.

Thank you in advance.

---

[ballardw]

Do you want a data set or a report?

On way for a quick report

Proc tabulate data=have;

   class date rating;

   table rating=' ' all='Total',

            (date=' ' All='Total') *n;

run;

[thb]

Hi Ballardfw,

Thank you for your response.  While the report is exactly what I'm looking for, I need to create a table with it for exporting.

[Reeza · Accepted solution]

You can use ODS EXCEL to export output directly to a file.

ods excel file='C:\temp\demo.xlsx';

proc freq data=have;
table rating*date/ out=want;
run;

ods excel close;

This also creates a data set called WANT with the values you need. If you need it exactly as shown you can add a proc transpose to switch it to that format.