Displaying a Value Across Columns

DavidPhillips2 — Fri, 21 Apr 2017 14:45:54 GMT

How do I display a value across columns, in this case column percent? I am trying to replace the ones with values.

proc report data=CombinedpctTable;
column MINORITY_STATUS academic_period_desc;
define percent / analysis sum /*format=percent8.*/;
define MINORITY_STATUS /group;
define academic_period_desc /across;
run;

ACADEMIC_PERIOD_DESC MINORITY_STATUS Fall 2011 Fall 2012 Fall 2013 Fall 2014 Fall 2015 Fall 2016

Minority

Re: Displaying a Value Across Columns

BrunoMueller — Fri, 21 Apr 2017 15:21:56 GMT

By default the number of rows is displayed. You can use nesting like this classVar, analysisVar or the other way round.

the code sample also show how to use the same column more than once by giving it an alias, this allows you to define each column individually.

code sample:

proc report data=sashelp.cars;
  column type origin, invoice invoice=invoice2, origin=origin2;
  define type / group;
  define origin / across;
  define origin2 / across;
  define invoice / analysis sum format=comma12.;
  define invoice2 / analysis sum format=commax12.;
run;

Bruno

topic Re: Displaying a Value Across Columns in ODS and Base Reporting

Displaying a Value Across Columns

Re: Displaying a Value Across Columns