Proc report

raja777pharma — Wed, 12 Feb 2020 10:27:15 GMT

Hello Team,

I am facing order issue and group display in proc report.

I need to rtf file output as per below screen shot 1 & 2 (both are same table but need in tow pages) and data was attached excel sheet

i have created titles and foot notes

In excel sheet also i mentioned rows orders (gpx gpx1) as per shell

Re: Proc report

ballardw — Wed, 12 Feb 2020 15:53:54 GMT

At least provide the code you have so far for proc report.

If I have to create data from an Excel spreadsheet it is very likely that I will make choices such that my SAS data set is not the same as yours.

Provide example data in the form of a data step. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Proc Report supports an option Called Preloadfmthat will force display order. I can't tell if you may also want/need a Multilabel format because without ANY values or description it is not possible to determine if your "decision" blocks are supposed to have a total for subgroups or not.

Statistics indicated with (xx.x%) are not defined as to what the denominator should be and I'm not going to guess.

topic Re: Proc report in SAS Programming

Proc report

Re: Proc report