topic Re: Summary Report in SAS Programming

Summary Report

Kalai2008 — Fri, 10 Nov 2017 14:55:42 GMT

I have a dataset like this

ID Issue Fixed
1 Issue 1 yes
2 Issue 2 no
3 Issue 3 yes
4 Issue 1 yes
4 Issue 3 no
5 Issue 1 no
5 Issue 2 yes
5 Issue 3 no

........
There are 3 Issues (Issue1-Issue3), Each id can fall into multiple issues.

I want to get a summary report like this. I tried Proc report, but I am not getting my desired output.

Issue Yes no Total
Issue 1 2 1 3
Issue 2 1 1 2
Issue 3 1 2 3

Thanks

Re: Summary Report

PaigeMiller — Fri, 10 Nov 2017 14:45:58 GMT

@Kalai2008 wrote:

I have a dataset like this

ID Issue Fixed
1 Issue 1 yes
2 Issue 2 no
3 Issue 3 yes
4 Issue 1 yes
4 Issue 3 no
5 Issue 1 no
5 Issue 2 yes
5 Issue 3 no

........
There are 5 Issues (Issue1-Issue5), Each id can fall into multiple issues.

I want to get a summary report like this. I tried Proc report, but I am not getting my desired output.

Issue Yes no Total
Issue 1 2 1 3
Issue 2 1 1 2
Issue 3 1 2 3

Thanks

I see only 3 issues, not 5.

Show us your PROC REPORT code, and we should be able to help you fix it.

Re: Summary Report

Kalai2008 — Fri, 10 Nov 2017 14:53:54 GMT

Sorry there are 3 Issues.

Proc report data=test;

column issue fixed id;

define issue/group;

run;

Re: Summary Report

RW9 — Fri, 10 Nov 2017 14:55:45 GMT

Not tested as no test data, but:

proc sql;
  create table WANT as
  select  ISSUE,
          sum(case when FIXED="yes" then 1 else 0 end) as YES,
          sum(case when FIXED="no" then 1 else 0 end) as NO,
          count(*) as TOTAL
  from    HAVE
  group by ISSUE;
quit;

Re: Summary Report

Kalai2008 — Fri, 10 Nov 2017 15:00:53 GMT

Thank you so much. It worked in Proc SQL. Is there any way I can do this in Proc Report or Proc Summary?..

Re: Summary Report

Ksharp — Sat, 11 Nov 2017 10:57:19 GMT

It is best for proc tabulate.

data have;
input id Issue  & $20.   Fixed $;
cards;
1       Issue 1    yes
2       Issue 2   no
3       Issue 3   yes
4       Issue 1   yes
4       Issue 3   no
5       Issue 1   no
5      Issue 2   yes
5      Issue 3   no
;
run;

proc tabulate data=have;
class issue fixed;
table issue,fixed*n all;
keylabel n=' ';
run;