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
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-dat... 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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: