topic Re: Count by Variable Groups in SAS Procedures

Count by Variable Groups

thb — Thu, 06 Sep 2018 16:16:08 GMT

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.

Re: Count by Variable Groups

Reeza — Thu, 06 Sep 2018 16:33:46 GMT

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.

Re: Count by Variable Groups

ballardw — Thu, 06 Sep 2018 16:34:38 GMT

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;

Re: Count by Variable Groups

thb — Thu, 06 Sep 2018 16:39:16 GMT

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.

Re: Count by Variable Groups

Reeza — Thu, 06 Sep 2018 16:41:44 GMT

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.