Hi Rick,   Yes, I got this way before, but in this way, SAS outputs P-value table in as a matrix (as shown below). Then I have to write a long code to reorganize the p-values along with group comparison so they can display as one column (as the last column in the table shown in my question). I think that's a complex way.... Least Squares Means for effect group Pr > |t| for H0: LSMean(i)=LSMean(j) Dependent Variable: Variable i/j 1 2 3 4 1   0.0047 <.0001 <.0001 2 0.0047   0.0045 0.0001 3 <.0001 0.0045   0.2270 4 <.0001 0.0001 0.2270     Any way to show the p_values in the last column instead of star signs like in the below table directly? Comparisons significant at the 0.05 level are indicated by ***. group Comparison Difference Between Means 95% Confidence Limits   (1) Toddler - (2) Young 8.862 2.732 14.992 *** (1) Toddler - (3) Child 16.756 10.764 22.747 *** (1) Toddler - (4) Teen 20.183 13.927 26.438 *** (2) Young   - (1) Toddler -8.862 -14.992 -2.732 *** (2) Young   - (3) Child 7.894 2.467 13.320 *** (2) Young   - (4) Teen 11.321 5.604 17.038 *** (3) Child   - (1) Toddler -16.756 -22.747 -10.764 *** (3) Child   - (2) Young -7.894 -13.320 -2.467 *** (3) Child   - (4) Teen 3.427 -2.141 8.995   (4) Teen    - (1) Toddler -20.183 -26.438 -13.927 *** (4) Teen    - (2) Young -11.321 -17.038 -5.604 *** (4) Teen    - (3) Child -3.427 -8.995 2.141     Thanks, C ... View more

Hi C,   I would use into: with proc sql to obtain the pvalues.   And then use the nmvar or mvar statement to plot those p-values. So it's quite similar to what you've done already, but instead of manually entereing the numbers, the numbers are already in a macro variable.   Also you don't have to use the nmvar or mvar statement.   You could also just use something like this:   entry "Toddler S = 0.518 p = &pvalue1; Young S = 0.383 p = &pvalue2" / textattrs = (weight = bold);   After creating the pvalue1 and pvalue2 macro variables.   The code in this paper shows how I've created macro variables with the into clause and then displayed those values on the plot.   http://support.sas.com/resources/papers/proceedings13/243-2013.pdf   Many thanks,   Kriss   ... View more

Hello C,   Here is an example that you can use and edit. Basically you need to create the observations in your dataset at the correct y value and use the markerchar option:   data cars; set sashelp.cars; run; data cars2; invoicey = 100000; make = "Acura"; char = "*"; output; invoicey = 100000; make = "Audi"; char = "*"; output; invoicey = 100000; make = "BMW"; char = "*"; output; run; data cars3; set cars cars2; run; proc sgplot data = cars3; where make in ("Acura" "Audi" "BMW"); scatter x = make y = invoicey / markerchar = char markercharattrs=(size = 15 color = red); vbox invoice / category = make; run;   Many thanks,   Kriss  ... View more

yes it is possible. If you would like to see lots of examples with sample code check out Robert Allisons work at http://robslink.com/SAS/#!   PROC REG also has quite a few Proc reg data=sashelp.class; model height=weight; run; plotting capabilities.  there is even a PLOT statement. ... View more

the keywords for the INSET statement are listed in the PROC UNIVARIATE documentation. It sounds like you want the PROBS option. Here is some code for data in the SASHELP data set, which everyone can access:   proc univariate data=sashelp.cars normal; var enginesize; class Origin; histogram enginesize / nrow = 3 odstitle = "VAR" normal kernel nohlabel vscale = percent; inset N = 'N' MEDIAN (8.2) MEAN (8.2) STD = 'Standard Deviation'(8.3) PROBS /* <== p-value for signed rank test */ / position = nw ; ods select histogram TestsForLocation; run; ... View more

It sounds like you're using PROC TEMPLATE incorrectly, but you haven't provided us enough information to tell you where or how to fix it. Really all you've stated is that somethings not working...   PROC TEMPLATE supports dynamic variables and should be a 'template' that can be reused so I suspect you're using it incorrectly or not using all the features available.  ... View more

Well, yes it can be done...     Variable_1 A B C   Child Young Teen       Variable_2 D E F   0.3 0.4 0.5     but I suspect you're about to say "but that's not what I want", because it doesn't make a great deal of sense. If you tell us what's wrong with this, we'll get closer to what you need. ... View more

data have; input Col_1 Col_2; cards; 1 1 2 2 3 3 4 5 5 6 6 7 7 9 8 10 ; run; data want; if _n_=1 then do; if 0 then set have; declare hash h1(dataset:'have'); h1.definekey(key:'col_1'); h1.definedone(); declare hash h2(dataset:'have'); h2.definekey(key:'col_2'); h2.definedone(); end; set have; if h1.check(key:col_2)=0 or h2.check(key:col_1)=0; run; ... View more

Sounds like your method of importing from Excel did not convert the stored value from Excel Dates in either SAS dates or Character strings.  To convert your numbers to SAS dates you add the negative number that is the SAS date for 01JAN1900 and subtract 2 to account for difference in how the first day is done and one mistake that Excel has for a leap year somewhere along the way between 1900 and 1960.  Add the date format you want, preferrable one that uses four digits for the year.   data _null_; do have=42143, 41948 ; want = have + '01JAN1900'd -2 ; put (have 2*want) (=10. =10. =yymmdd10.); end; run; have=42143 want=20227 want=2015-05-19 have=41948 want=20032 want=2014-11-05   ... View more

Since you said, "template", I will assume you are using GTL for this example. Your example is also using a cell header, but the text does not appear to be generated by classification, so I will assume you are using an ENTRY inside of a CELLHEADER block. Your ENTRY statement should look something like this:   entry {unicode '03C1'x} " = 0.338; p < .001" / textattrs=GraphUnicodeText;   You do not need the ODS escape character because entries in GTL support the unicode, sup, and sub escapements outside of quoted strings.   Since you're referencing a character in the "03" range, your default font might not contain that character. If it doesn't, add the TEXTATTRS reference I gave above to use a more full-featured Unicode font.   Hope this helps! Dan   ... View more