topic Re: PROC REPORT in SAS Programming

PROC REPORT

Maneesh27 — Mon, 27 Feb 2023 06:14:13 GMT

HOW TO GET THE THE OUTPUT AS 'F-TOTAL' USING PROC REPORT.

Re: PROC REPORT

PaigeMiller — Mon, 27 Feb 2023 12:48:51 GMT

You will need to show us your existing code. You will also need to provide sample data, as working SAS data step code (which you can type in yourself, or follow these instructions). Lastly, many of us will not download attachments, you can show your output by including it in your reply by making a screen capture and then clicking on the "insert photos" icon.

Re: PROC REPORT

Patrick — Mon, 27 Feb 2023 12:56:42 GMT

@PaigeMiller Just copy/paste of an image taken for example with the Snipping Tool works also since quite a while ago. One of the improvements to the forum UI which I really appreciated.

@Maneesh27 I'm one of these people who just need a bit more input from you before spending time answering your question (=help us to help you).

Re: PROC REPORT

PaigeMiller — Mon, 27 Feb 2023 13:02:50 GMT

@Patrick wrote:

@PaigeMiller Just copy/paste of an image taken for example with the Snipping Tool works also since quite a while ago. One of the improvements to the forum UI which I really appreciated.

I'm not sure I understand this ... unless you are trying to instruct @Maneesh27 on how to get his screen capture into his reply.

Re: PROC REPORT

Patrick — Mon, 27 Feb 2023 13:25:57 GMT

@PaigeMiller Just saying that you don't need anymore the "insert photo" function but that you just can copy/paste your image into the browser window.

...but anyway: We actually want primarily code and not pictures from the OP.

Re: PROC REPORT

ballardw — Mon, 27 Feb 2023 15:59:49 GMT

Is your question about getting the text of "F-Total" into that column or getting the sums?

Note: if you provide pictures please do not show white text on light colors like the pink shown, the poor contrast is hard to read and has been known since the middle ages, better is to avoid the colors entirely and show black on white.

Re: PROC REPORT

Cynthia_sas — Mon, 27 Feb 2023 16:59:44 GMT

Hi:

I agree with all the previous comments. It would have been better for you to show output without all the colors that made the output hard to read. Also, while it looks like you're using SASHELP.CLASS, it's not clear what ordering you've done or want or whether you just used SASHELP.CLASS instead of your own data for the example.

This report approximates what your report looks like, the ordering is not entirely as you show. Also, the colors are not done. If you know how to do those colors in PROC REPORT, then I leave that piece to you. The key to making this work to have the subtotals you want is to make sure the column for the SEX variable is wide enough to fit the text for the subtotal label. to that end, I have made a temporary dataset called NEWCLASS with a length of 15 for the SEX variable, so the column can hold the labels at the break.

Hope this gets you started. For more help, please post your data and ALL your code.

Cynthia