Hello all; I am wondering if there is a "simple" way to "split" a legend marker so that: Jan07/MD=x/RN=x becomes Jan07 MD=x RN=x I see the split function is available for other SAS graphing capabilities, just not SGPLOT. I have been poking around all the documentation for SGPLOT and Xaxis and not find much except for the graphics template language, which I am not ready to dive into just yet. Much thanks! Lawrence ... View more

Hello SAS forum; OK, so I am trying to parse specific strings of numbers into individual variables so that I have for example 1,2,3 1,4,5 1,5,7 3,10 etc etc Here is my problem, if I try to use the index or Rxparse functions for the characters '10' I still get a 1 if 1 is anywhere in the string. Is there a way to do a literal string match that matches exactly the '10' but not the '1' Thank you. ... View more

Hello all; I would like to know more about how to modify the ordering sequence in the X-axis output statement? Currently I have the X-axis sequence as 2007Q1 2007Q2 etc etc. However I have been asked to use Jan-March 2007 vs 2007Q1. However, when I attempt to use vbar to graph it then alphabetizes so instead of getting: Jan-March 2007 Apr-Jun2007 Jan-March2008 I get: Jan-March 2007 Jan-March2008 Apr-Jun2007 Also on more question-Is there a way in within the X-axis to use ODS special characters such as /n so that I can relay additional informational such that: Jan-March 2007 a=n b=n c=n I know I am asking a tall order but any help would be greatly appreciated as I cannot find anything in SAS documentation. Lawrence ... View more

Hello! I have a question about the autocall facility for invoking macros and perhaps I lack some basic understanding that needs clarification? I have a macro called fy that is used for fiscal year calculations. It does work as it is embedded in most of my SAS programs. I saved it as fy.SAS in a folder 'G:\SASprograms\macros' In a new program I start with: filename mymacros 'G:\SASprograms\MACROS'; options sasautos=(sasautos mymacros) mautosource; %fy data x; x="&FYPR"; y="&curmonth"; run; However I get the error that the apparent invocation of macro fy is not resolved that leads to errors. My assumption is that I should not have to run the fy program beforehand or is this wrong? My understanding is that this program would compile the macro only when called in this program but perhaps I am wrong? My ultimate question, is this possible that I can invoke a macro in a program without having to run the separate program. Any assistance would be greatly appreciated! ... View more

Hello all- One last question- How I request a specific lineattrs & markerattrs for a specific unit of measure so that if unit A then: lineattrs=(pattern=solid thickness=2px color=blue) markerattrs=(symbol=circlefilled ) Thank you again. LB ... View more

Hello all- another possible brain teaser that any assistance would be much appreciated- I have a macro that takes all the units and produces a graph for each unit. So far, no difficulty except that I would like to change two things: Based on a specific unit I would to be able to change the refline statement as needed. Also, is there is any way to use if/then statements in the footnotes of each graph that incorporate data from other macros- The code is shown below, any assistance much appreciated! LB %macro split (data=, var=); proc sort data=&data(keep=&var) out=values nodupkey; by &var; run; data _null_; set values end=last; call symputx('site'||left(_n_),&var); if last then call symputx('count',_n_); run; %put _local_; DATA _NULL_ ; select(&var); %do i=1 %to &count; /*CRBSI GRAPHS */ ODS GRAPHICS ON /IMAGEFMT=PNG HEIGHt=3in width=5in SCALE=OFF ANTIALIAS=ON IMAGENAME="CRBSI_&&site&i" BORDER=NO; title "&&site&i"; proc sgplot data=BASIC_OUT_II NOAUTOLEGEND ; WHERE UNIT1 IN ("&&site&i") and _type_ =7 and moi>'30Aug07'd; series x=Moi2 y=CRBSI_RATE / datalabel=CRBSIgraph lineattrs=(pattern=solid thickness=2px color=blue) markerattrs=(symbol=circlefilled ) markers group=UNIT1; yaxis label='CRBSI Rate per 1000 DD' GRID VALUES = (0 TO 15 BY 2.5); xaxis label =' '; REFLINE 4.56 / TRANSPARENCY = .1 LINEATTRS=(pattern=dot thickness=3px color=green) LABEL = ('UCSF IAP Goal:4.56') LABELLOC=OUTSIDE ; REFLINE .5 / TRANSPARENCY = .1 LINEATTRS=(pattern=dot thickness=3px color=red) LABEL = ('NHSN 25%ile (.5)' ) LABELLOC=OUTSIDE ; run; footnote goes here. ODS GRAPHICS OFF; ... View more