completely flummoxed (guessing it's something really simple) - why doesn't this order by the data?   data test; input id value; cards; id value 1 8.8 2 24 3 15 4 7.0 5 15.7 ; run; proc sort data=test; by id; run; /*tried this, doesn't change order: proc sort data=test; by descending id; run; */ proc sgplot data= test; scatter y=id x=value ; yaxis discreteorder=data; run;       ... View more

I've got summary data, trying to create a report with Proc Report, with two Across variables.   i've included some stipped down sample data - i can create two reports separately, but can't figure out how to put them together. any suggestions would be greatly appreaciated! Dave     data a; input grade type1 $ count1 type2a $ type2b $ count2; cards; 1 A1 1 . . . 1 B1 1 . . . 1 C1 1 . . . 1 . . A2 A2a 1 1 . . A2 A2b 1 ; run;   title1 'type1 - works fine'; proc report data=a; columns ("Grade" grade) type1,(count1); define grade/' ' group; define type1/' ' across; define count1/' ' sum; run;   title1 'type2a/type2b - works fine'; proc report data=a; columns ("Grade" grade) type2a, type2b,(count2); define grade/' ' group; define type2a/' ' across; define type2b/' ' across; define count2/' ' sum; run;   title1 "Doesn't Work"; proc report data=a; columns ("Grade" grade)  (type1,(count1))  (type2a, type2b,(count2)); define grade/' ' group; define type1/' ' across; define count1/' ' sum; define type2a/' ' across; define type2b/' ' across; define count2/' ' sum; run;   ... View more

  Any ideas why my Header Border works in pdf but not in powerpoint? (or, any ideas what I could do differently to get it to work?)   included stripped down program code. thanks! Dave   data test; input School $ val1 val2; cards; A 1 2 B 1 2 ; run; ods pdf file = 'C:\temp\test.pdf'; ods powerpoint file = 'C:\temp\test.pptx'; ods escapechar = "^"; proc report data=test; column School ("^{style[borderrightcolor=Black borderrightwidth=8 ] Span}" val1 val2); define val1/display style=[just=center FONT_SIZE=12pt cellwidth=1.4 cm cellheight=.35 cm borderrightwidth=5];; define val2/display style=[just=center FONT_SIZE=12pt cellwidth=1.4 cm cellheight=.35 cm borderrightwidth=8 borderrightcolor=Black];; run; ods pdf close; ods powerpoint close; ... View more

I've looked, and appears the answer is no, but thought I would ask - is there a way to output the tables from the effectsize option? thanks, Dave ... View more

any suggestions how I put a frame/border around the entire page, in an ods pdf output? (I've got a number of layout pieces, and would like them all enclosed in a single frame - what the boss wants) thanks, Dave     ... View more