Thanks for the suggestion @Kurt_Bremser !   Clear case of having had a way too busy week. Could have sworn that the following syntax created just a CSV file named class.xlsx earlier, but it's actually a real XLSX!       ... View more

What version of Viya are you using? Have you tracked this issue with SAS Tech Support and if so what was the response? If not then I suggest you do so and then add their response to this post. ... View more

Try this: select( test ); when( 'b' ) when( 'B' ) put 'Beginning'; when( 'm' ) put 'Middle'; when( 'e' ) put 'End'; end; ... View more

Data Rawtbl; input ID 1-2 Region$ 4-12 Division$ 13-29 Type 31 expenditures 33-37; cards; 1 Northeast New England 1 10 2 Northeast Middle Attlantic 1 20 3 Northeast Middle Attlantic 2 30 4 Northeast Middle Attlantic 2 40 5 Northeast New England 2 50 6 West Mountain 1 50 7 West Mountain 1 60 8 West Mountain 2 70 9 West Pacific 2 80 10 West Pacific 1 90 11 West Pacific 2 100 ; Run; options nodate pageno=1 linesize=80 pagesize=60; proc report data=Rawtbl nowd; columns region division type,expenditures; define region/group noprint; define division/group ' ' style={pretext=' ' asis=on}; define type/across format= usetype.; define expenditures/analysis sum format=dollar32. ' '; compute before region; line @1 region $40.; endcomp; title 'Energy Expenditures for Each Region'; title2 '(millions of dollars)'; run; ... View more