DATA Step, Macro, Functions and more

order of variables in proc report

Reply
Super Contributor
Posts: 673

order of variables in proc report

ods html file='C:\Documents and Settings\skap\Desktop\xyz.xls';
proc report data=nation_first nowindows;
column provider region,(nor ms );
define provider/group;
define region/across;
define nor/analysis sum 'Units' format=comma12.;
define ms/analysis sum 'MS' format=percent8.2;
run;
ods html close;

In the above report "region" has following values:
CENTRAL,MIDATLANTIC,EAST,ROCKYMOUNTAIN SOUTHEAST ,WEST, NATION

When I create the report the variables are displayed alphabetically i.e CENTRAL,EAST...WEST.
How to dispaly the variables in the order shown above?
Thanks for yor help in advance.
Super Contributor
Super Contributor
Posts: 3,174

Re: order of variables in proc report

Explore the ORDER=INTERNAL parameter for the DEFINE statement.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument below:

proc report across "order=internal" site:sas.com
Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation