BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8
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.
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 839 views
  • 0 likes
  • 2 in conversation