topic Re: PROC Report with groups across, statistics down? in ODS and Base Reporting

PROC Report with groups across, statistics down?

TimH — Fri, 02 Feb 2018 14:44:06 GMT

I am sure this was probably asked before but I don't know which keywords to bring up what I want - I searched and got a lot of PROC REPORT ACROSS variable stuff but nothing fits just yet, so I'm entering a new message. Here's what I want to do: I have datasets that have observations over time, with an identifier, date, and various measurement variables. I want to report, paged or otherwise grouped by identifier, with each date a column, and each variable a row with the variable label on the left and the values under the date columns.

What is the best way to go:

1. Summarize (if necessary) the observations by date, then do PROC TRANSPOSE and PROC PRINT

2. PROC REPORT ?

I am trying to figure out the latte but any and all advice is appreciated

Re: PROC Report with groups across, statistics down?

RW9 — Fri, 02 Feb 2018 15:12:25 GMT

1). Summarise your data, then do a proc transpose (note I don't use all uppercase!) then you have the option of doing either a proc print or a proc report on the data you have. Personally I really don't like doing data manipulation in proc report which is a reporting procedure.

Re: PROC Report with groups across, statistics down?

ballardw — Fri, 02 Feb 2018 15:23:10 GMT

See this example using some example data that you should have available:

proc tabulate data=sashelp.class;
   class sex; /*your identifier role*/
   class age; /* your "across"*/
   var height weight; /*variables for statistics*/
   table sex,
         (height weight) * (mean max min std),
         age
   ;
run;

The table statement can have 3 "dimensions" separated by commas. If all three are used the first is "page", the seconds is what goes in the row and the third is column.

Re: PROC Report with groups across, statistics down?

TimH — Fri, 02 Feb 2018 22:45:23 GMT

Ah, good old TABULATE. One of my favorite PROCs and that definitely will do what I want to do.