Please note: This is not about editor Macros or abbreviations.   I am NOT interested any editor-based abbreviation or editor -macro solution to this.  (Although they are admittedly helpful, that's out of scope).   I have a number of macros defined, that are loaded in autoexec process flow.  As of version 7.15 HF3 (7.100.5.6132) (32-bit), I am not seeing my macros autocomplete when I type in their name in the editor.   Also:   Autocomplete is already turned on via the tools > Editor Options menu path. I use "third character" autocomplete  As an example, I have %macro meantable(x= /* data table */,y=/* statistics used */,z=/* version  */);  ...<stuff> %mend;   I would like to type %mea and have the word %meantable (and any other macros defined that start with  the characters mea) appear in the editor.  After I type in the open paren, I'd like to see the integrated documentation for x,y, and z.   Currently this is not happening.  ... View more

I have yet to get an optimal match to run without a failure.   If I have control with M (#cols=VC) and Treatment with N(# cols=VT) (observations, how can I estimate how much resources the optimal match will take?   Every optimal match that I've tried  failed due to non-existence of a good match.  Most variables are binary variables, and distance is defined by LPS (log propensity score).   Obviously there are a LOT of factors that would affect the ability to create an optimal match.  Without knowing much more about my data, are there any general guidelines we should be aware of?  Are there any bounds above which an optimal match would be extremely unlikely?   Here's my error: ERROR: A feasible optimal fixed ratio matching that has the specified parameters does not exist. NOTE: The data set WORK.OUTGS has 0 observations and 87 variables. NOTE: PROCEDURE PSMATCH used (Total process time): ... View more

This post should contain one format statement, one proc gchart and one question. If you are not seeing all of these, it means my question was truncated. proc format; value xxx 0 <- .10 = '0 to 10%' .10 <- .30 = '10% to 30%' .30 <- .60 = '30% to 60%' .60 <- high = 'More than 60%'; run; proc gchart data=inputdata; format val xxx.; vbar val / freq=_freq discrete; run; quit; How can I create this same plot using PROC SGPLOT? I'm having trouble finding the options I need either in the XAXIS statement of SGPLOT or the options. I'm probably just missing something obvious that's already in the documentation, but can anybody help me make my plot? The point of this for me is to learn SGPLOT, so please don't say "if you're already doing it, why worry". Message was edited by: mftuchman Message was edited by: mftuchman Message was edited by: mftuchman ... View more

I am curious about how I can use CELLSTYLE AS statements to style an entire row when one row of an underlying ODS table may corresponding to several rows of physical output. Consider the following code: ods output summary=s2; proc means nway mean std data=sashelp.class; var height weight age; class sex; run; ods output close; /* I print this out for reference to see the underlying output table */ proc print data=s2; run; 1. I want to know if it is possible using ONLY the TEMPLATE procedure, editing the base.summary template, how to highlight the rows containing AGE in the PROC MEANS output. 2. How to color bar the rows of this table, but using _ROW_ expression does not have the desired effect because PROC TEMPLATE sees the input table as having only two rows, not 6.] Message was edited by: mftuchman Also, I'm curious about why my tags did not work. Message was edited by: mftuchman Message was edited by: mftuchman ... View more