topic Re: SAS ODS HOW TO GROUP COLUMNS in ODS and Base Reporting

SAS ODS HOW TO GROUP COLUMNS

prsr — Thu, 09 May 2024 16:39:10 GMT

Hi there,

I am using ods excel along with proc report. Is there a way to achieve this using ods excel.

The equivalent of excel is here. (In excel select columns that need to be grouped, then go to DATA menu and then group sub menu.

Thanks in advance

Re: SAS ODS HOW TO GROUP COLUMNS

ballardw — Thu, 09 May 2024 17:19:56 GMT

As a minimum include your current ODS Excel and Proc report code and indicate which VARIABLES in the report are supposed to be "grouped".

I don't use that feature in Excel, so what is the purpose of grouping the columns in Excel?

Re: SAS ODS HOW TO GROUP COLUMNS

PaigeMiller — Thu, 09 May 2024 19:16:01 GMT

Open a brand new empty Excel spreadsheet, then type in what you want PROC REPORT to look like, using actual or fake variable names, showing a few rows of actual or fake data, merging columns or cells in Excel as needed to display the look you want. Then make a screen capture of this Excel file so we can see it too — do not attach files, provide the screen capture via the "Insert Photos" icon.

Re: SAS ODS HOW TO GROUP COLUMNS

prsr — Thu, 09 May 2024 20:13:23 GMT

Hi Paige,

Sorry for the confusion and not providing sufficient information. Pls see if the attached explains the problem.

Thanks,

prsr

Re: SAS ODS HOW TO GROUP COLUMNS

Chevell_sas — Thu, 09 May 2024 20:18:47 GMT

ODS Excel doesn't have the capability of creating grouped data currently. This has been added as a suggested feature.