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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.