topic proc report in SAS Programming

proc report

JibJam221 — Thu, 24 Jan 2019 18:09:03 GMT

Hi,

in creating report, I am trying to list the first and last names of individuals with a count of surveys completed. In my report, one individual may be listed more than once, however proc report leaves a blank space (to represent a duplicated name). Is there any way to have the name printed again, instead of leaving blank?

proc report data=ITr out=ITre(drop=_break_) nowd;
column ID LName FName survey n;
define ID/Group;
define LName/Order 'Last';
define FName/Order 'First';
define survey/across 'surveys for 2018';
rbreak after / dol skip summarize ;
compute after;
ID='Total';
endcomp;
run;

Re: proc report

Reeza — Thu, 24 Jan 2019 18:21:03 GMT

Try adding display as an option after the slash.

Re: proc report

JibJam221 — Thu, 24 Jan 2019 18:32:31 GMT

thanks! Is there any way I could do order and display for the ID? Id the the ID to show up both times as well.

Re: proc report

Cynthia_sas — Fri, 25 Jan 2019 01:27:48 GMT

Hi:

Without data, it's hard to run your code, especially since you have an ACROSS variable. However, the issue of blanks for ORDER or GROUP items will happen whether you have ACROSS variables or not.

But, making some fake data based on SASHELP.CLASS,

and then running PROC REPORT, you can see where the duplicate values were suppressed. However you can cause PROC REPORT to "fill-in" the blanks for you using a COMPUTE blocks, like this:

and there is an alternate coding technique that would produce the same results. You can make all the changes in the COMPUTE block for name because of the left-to-right rule of PROC REPORT, the COMPUTE block for NAME can "touch" the cells for ID and CHARAGE in order to fill in the blanks The changed code is shown below. The rest of the REPORT code is the same:

Hope this helps,

Cynthia