Hi I have a proc report where I need to null some values based on a condition. It works fine when i have a "simple" proc report, but when I make a crosstable I have problems. I have made an example of the two reports below: In the first table the mean for sex=1 is set to 0, since there are fewer than 7 players. I want the same for the second table, ie the only mean that should show is the mean for sex=2 and category=2. Since the number of categorys in the input table varies, I can´t use the _cx_ to fix this. Any suggestions? Tks in advance Jenny data test; input sex category salary; cards; 1 2 11000 1 2 10000 1 3 15000 1 3 16000 1 2 14500 1 2 13000 2 2 10000 2 3 10000 2 2 12000 2 2 13000 2 2 15000 2 2 17000 2 2 15000 2 2 17000 ; run; ods listing close; ods html body = 'test.html' style=seaside; title 'This report works fine , with the mean nulled for less than 7 players'; proc report data = test nowd; column sex salary=lant salary=lmean; define sex / group "Sex" ; define lant / n format = nlnum8. 'Players' ; define lmean / mean format = nlnum8. 'Mean' style={just=r} ; compute lmean; if lant lt 7 then lmean = 0; endcomp; run; title 'The columns for mean doesn´t get nulled'; proc report data = test out = tt nowd; column sex category , ( salary=lant salary=lmean ) ; define sex / group "Sex" ; define category / across "" across; define lant / n format = nlnum8. 'Players' ; define lmean / mean format = nlnum8. 'Mean' style={just=r} ; compute lmean; if lant lt 7 then lmean = 0; endcomp; run; ods html close; ... View more

Hi all Is it possible to use proc greplay with graphs created with ods graphics? The graphs created by ods graphics is png format, and I can´t figure out how to refter to them in my proc greplay. Tks for advice Best regards Jenny ... View more

Hi Anybody know if there is a way to get the boxes in a grouped boxplot above eachother instead of grouped? For example I plot salary per state and gender and I want salary on the y-axis and state on the x and one box per gender. On the x-axis i only want the state once, not twice as it is in this plot: data kon; length gender salary 8 state $15; input gender salary state; cards; 1 10000 Mora 1 15300 Stockholm 1 11500 Sala 1 12300 Gävle 1 11300 Mora 2 16800 Gävle 2 12500 Stockholm 2 13500 Norrköping 2 16200 Norrköping 2 17500 Sala 2 11700 Stockholm 2 17100 Mora ; run; data kon; set kon; do i = 1 to 100; salary = salary+(i); output; end; run; ods graphics on; proc sort data=kon; by gender; run; proc boxplot data=kon; plot salary*state (gender) / boxstyle = schematic horizontal ; run; ods graphics off; thanks in advance ... View more

Hello! In v 9.2 you can make a horizontal boxplot if you use ods graphics. I am trying to change the color of the boxes, with the option cboxfill. But it doesn´t work. I works fine without ods graphics, but then the plot become vertical. Do I have to change in some templates or something to get the fill colour to be right? example: data temp; input id growth light temp; cards; 1 4.55 1 1 2 4.24 1 1 3 4.89 1 2 4 4.88 1 2 5 5.01 1 3 6 5.11 1 3 7 5.55 2 1 8 4.08 2 1 9 6.09 2 2 10 5.01 2 2 11 7.01 2 3 12 6.92 2 3 ; run; *2. Dictionary of variable values for readability; proc format; value lightf 1='1=low' 2='2=high'; value tempf 1='1=cold' 2='2=lukewarm' 3='3=warm'; run; quit; proc sort data=temp; by temp; run; ods graphics on; proc boxplot data=temp; plot growth*temp /boxstyle=skeletal horizontal cboxes=cx153e7e cboxfill=red; title 'Fish Growth by Temperature'; format temp tempf.; run; ods graphics off; tks for advice Br Jenny ... View more

Hi I want to keep the leading 0 when I am exporting to excel through tagsets.excelxp. I try to use the format @ but it doesn´t work. Any ideas? data ett; text = '05566'; run; ods path SASUSER.TEMPLAT(UPDATE) SASHELP.TMPLMST(READ) SASHELP.TEMPLAT(READ); ods tagsets.excelxp file="/sas/sasdata/MAExports/test.xls" ; proc print data = ett; ; var text/style(data)={tagattr="format:@"}; ; run; ods tagsets.close; ods path SASUSER.TEMPLAT(READ) SASHELP.TMPLMST(READ) SASHELP.TEMPLAT(READ); ... View more