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.
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.
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.
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;
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.