topic order of variables in proc report in SAS Programming https://communities.sas.com/t5/SAS-Programming/order-of-variables-in-proc-report/m-p/48431#M10011 ods html file='C:\Documents and Settings\skap\Desktop\xyz.xls';<BR /> proc report data=nation_first nowindows; <BR /> column provider region,(nor ms ); <BR /> define provider/group; <BR /> define region/across; <BR /> define nor/analysis sum 'Units' format=comma12.; <BR /> define ms/analysis sum 'MS' format=percent8.2; <BR /> run;<BR /> ods html close;<BR /> <BR /> In the above report "region" has following values:<BR /> CENTRAL,MIDATLANTIC,EAST,ROCKYMOUNTAIN SOUTHEAST ,WEST, NATION<BR /> <BR /> When I create the report the variables are displayed alphabetically i.e CENTRAL,EAST...WEST.<BR /> How to dispaly the variables in the order shown above?<BR /> Thanks for yor help in advance. Wed, 24 Jun 2009 15:01:48 GMT SASPhile 2009-06-24T15:01:48Z order of variables in proc report https://communities.sas.com/t5/SAS-Programming/order-of-variables-in-proc-report/m-p/48431#M10011 ods html file='C:\Documents and Settings\skap\Desktop\xyz.xls';<BR /> proc report data=nation_first nowindows; <BR /> column provider region,(nor ms ); <BR /> define provider/group; <BR /> define region/across; <BR /> define nor/analysis sum 'Units' format=comma12.; <BR /> define ms/analysis sum 'MS' format=percent8.2; <BR /> run;<BR /> ods html close;<BR /> <BR /> In the above report "region" has following values:<BR /> CENTRAL,MIDATLANTIC,EAST,ROCKYMOUNTAIN SOUTHEAST ,WEST, NATION<BR /> <BR /> When I create the report the variables are displayed alphabetically i.e CENTRAL,EAST...WEST.<BR /> How to dispaly the variables in the order shown above?<BR /> Thanks for yor help in advance. Wed, 24 Jun 2009 15:01:48 GMT https://communities.sas.com/t5/SAS-Programming/order-of-variables-in-proc-report/m-p/48431#M10011 SASPhile 2009-06-24T15:01:48Z Re: order of variables in proc report https://communities.sas.com/t5/SAS-Programming/order-of-variables-in-proc-report/m-p/48432#M10012 Explore the ORDER=INTERNAL parameter for the DEFINE statement.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument below:<BR /> <BR /> proc report across "order=internal" site:sas.com Wed, 24 Jun 2009 15:17:20 GMT https://communities.sas.com/t5/SAS-Programming/order-of-variables-in-proc-report/m-p/48432#M10012 sbb 2009-06-24T15:17:20Z