Hello all; Hope everyone had a good holiday. Question when using a compute statement- So I have a define statement that dictates specific colors based on a specific compliance rate- such that: DEFINE FYTD1 /"FYTD" format=percent10. style={background=colors.}; But then I have one row that is not a percentage but rather a number that I would like to calculate as an actual integer- So right now-420 becomes 42000%. I managed to solve the background color issue but how do I fix the other problem- So far I have tried: compute FYTD1; if _name_= 'Number Overall Observations' then do; call define (_col_, 'style','style={background=white}'); call define (_col_, 'format','format=8.2'); end; endcomp; */ Any suggestions would be much appreciated-Thank you. LB ... View more

Hi all. Happy holidays to all. I am using ODS & SGPLOT to export various graphs. However, they are coming out a little fuzzy. Does anyone else have issues with this. Are there better ways to produce graphs. Part of my code is below as to the ODS statements. Any asistance would be greatly appreciated. Lawrence ods listing GPATH='\\A:'; ODS GRAPHICS ON /IMAGEFMT=BMP ANTIALIAS=ON HEIGHt=2.75in width=5in SCALE=ON IMAGENAME="OverallCRBSI" BORDER=NO image_dpi=300; proc sgplot data=X; code ... ... View more

Hello all; In SGPLOT, I would like to make a simple dashed line with a label on the left side at a certain value, let's say 5 with specific color. How can this can be accomplished-easily? Been searching around the literature w/o much success. Thanks Lawrence ... View more

Hello all; I would like to incorporate different graphs in various reports. The problem I have is that I see mention of pre & post-image but is there a way so that instead of Var A B C would be replaced with images that correlate to those values through the use of a proc format statement or the like? If I use pre/post image I just get the first image. Many thanks in advance. Lawrence ... View more

Hello all; I am trying to accomplish two things: create a table with an underlying (line) graph that accompanies the table to output to PDF through PROC Report. However, the graph & table come from different sources. Currently, this works except that the graph prints to another page, and way too big. I have attempted to solve this by ysuing the ODS graphics on/width= height= but this has no effect. So essentially I have my proc report statements: ODS LISTING CLOSE; ... Proc Report data=x; ... endcomp symbol1 v=dot i=join; proc gplot data=BASIC_OUTPUT; where UNIT='y' and date>monthyear; plot crbsi_rate*moi; run; quit; Second question is that when the graph prints, it does not adhere to the ODS escape character and so the graphic does not print accordingly. Thank you again for your help... Lawrence ... View more

Back again...a newbie at ODS so I am doing this baby steps- At any rates is there to do a similar "split" within a column so that the text wraps to the next line- Incidentally I use proc format for the observations so that my proc format statement is: value $unitsvap '10 ICC'="ICC:10 &ICCVAP / Days without a VAP" ...code... What I would like is that it splits after the / into two lines. Thank you all again for your tips and advice... Lawrence ... View more

Hello everyone- two quick questions- One is that I have some overflow from one page to the next (about 4 lines + header). Is there a way to set a parameter to stop this from occurring. I have tried the LS option. That does not work. Also is there is a way to be rid of the gridlines within a specific column? Code follows as such: DEFINE UNIT/" " ORDER format=$units. style={background=lavender font_size=1 }; I would like to set the "box" without the grids. Thanks again. Lawrence ... View more