ods ExcelXP sheet_interval='bygroup'

Accepted Solution Solved
Reply
Regular Contributor
Posts: 229
Accepted Solution

ods ExcelXP sheet_interval='bygroup'

Hi...Is it possible to order the worksheets with labels from the bygroup variable values either in the order that they appear on the sas dataset or in the order from the largest to the smallest number of records(rows) that the worksheets have recorded.


Accepted Solutions
Solution
‎02-20-2014 06:49 PM
Super User
Posts: 19,772

Re: ods ExcelXP sheet_interval='bygroup'

Aren't they ordered in the BY Group order?

If so, custom sort your data and use the notsorted option on the by statement.

proc xxxxx data=have;

by bygroup NOTSORTED;

run;

View solution in original post


All Replies
Solution
‎02-20-2014 06:49 PM
Super User
Posts: 19,772

Re: ods ExcelXP sheet_interval='bygroup'

Aren't they ordered in the BY Group order?

If so, custom sort your data and use the notsorted option on the by statement.

proc xxxxx data=have;

by bygroup NOTSORTED;

run;

Regular Contributor
Posts: 229

Re: ods ExcelXP sheet_interval='bygroup'

Thanks Reeza....That did the trick...wasn't aware of the notsorted option for the by statement. Thanks once again.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 233 views
  • 0 likes
  • 2 in conversation