Hi Ian, there has been discussion on numeric to character variables as one imports from Excel into SAS. Please see below this discussion: Best of luck! Anca. ... View more

Hi. How about this: proc sort data = sashelp.class out = foo;by sex; data foo; length text $20.; set foo; by sex; if first.sex then do;     xPosition = 1;     yPosition = 20;     text = "Corr = 0.15";*replace with your macro variable; end; else do;     xPosition = 1;     yPosition = 20;     text = "Corr = 0.25";*replace with your macro variable; end; run; proc sgpanel data=foo noautolegend;       panelby sex;         scatter y=yPosition x=xPosition/ markerchar = text markercharattrs = (weight=bold);*this plots the "values for your correlation at x = 1 and y = 20 coordinates;         scatter y =weight x=age;         reg x=age y=weight;       title 'Some title'; run; ... View more

Hi. Some sample data to work with would help, but I would first suggest that instead of taking the variable "TIME" as is, I would first strip the date out of the "TIME" variable, thus obtaining the hour and minutes. So, say, you have time = 2012-08-01 8:49, what you really want is a way to strip the time from the date. BUT you need to also keep a count for the date (so if one is connected for 2 days and four hours, you actually count the days as well). Please provide some sample data. Thanks. ... View more

Jag, I do not know the answer to your java platform problem. Sorry, but hopefully someone around the forum will know it. Best of luck! Anca. ... View more

have you tried my suggestion? ODS PATH work.templat(update) sasuser.templat(read) sashelp.tmplmst(read); ?? ... View more

Could be. this is the error I get when I run the code as is (I like the exclamation mark at the end of the error!!!!) 1    proc template; NOTE: Writing HTML Body file: sashtml.htm 2 3       define style styles.colorramp; 4 5       parent=styles.default; 6 7 8 9 10 11      /* Define a lighter and darker shade of blue for the starting and ending colors. */ 12 13      style twocolorramp / startcolor=cxF3F7FE endcolor=cx6497EB; 14 15 16 17 18 19      /* When there are fewer than 3 response levels, GraphData1 and GraphData2 20 21         are used for the colors */ 22 23      style graphdata1 from graphdata1 / color=cxF3F7FE; 24 25      style graphdata2 from graphdata2 / color=cx6497EB; 26 27      end; ERROR: Template 'Styles.Colorramp' was unable to write to template store! 28 29   run; NOTE: PROCEDURE TEMPLATE used (Total process time):       real time           0.46 seconds       cpu time            0.37 seconds WARNING: Errors were produced. NOTE: The SAS System stopped processing this step because of errors. 30 ... View more

Apparently there is an error on read/write permissions, so you need to run this little piece of code before you run your original code: ODS PATH work.templat(update) sasuser.templat(read) sashelp.tmplmst(read); Good luck and let us know if it work! Anca. ... View more

I did, too. And there are several errors in the proc template. However, just the proc gmap gives the attached map. ... View more

using the sample code above, you could add a format that will add the superscript. I am actually confused about waht do you need. Basically, to add a superscript you define escapechar = '\', then add to the text you want superscript the "\{super b}" Hmmm... Can you give an example of the table? proc format;    value $ col demog = "demog\{super a}"    ae = "ae\{super b}"; quit; ods listing close; ods rtf file="Test output.rtf" style=rtfout; ods escapechar='\'; proc report data = test missing split="$" spacing=0 headline nowd; column sortord secnam pvalue; define sortord / order noprint; define secnam / order flow "Demographics$Variable\{super a}"; define pvalue / display flow "ANOVA$P-Value\{sub p}"; format secnam $col.; run; ods rtf close; ods trace off; ods listing; ... View more

OK, if you open the second paper you will see a good simple example: ************************************************************; data test; length secnam $15; input sortord secnam $ pvalue; cards; 1 demog 0.8812 2 ae 0.7112 3 disposition 0.8112 4 medicalhistory 0.9112 ; run; ods listing close; ods rtf file="Test output.rtf" style=rtfout; ods escapechar='\'; proc report data = test missing split="$" spacing=0 headline nowd; column sortord secnam pvalue; define sortord / order noprint; define secnam / order flow "Demographics$Variable\{super a}"; define pvalue / display flow "ANOVA$P-Value\{sub p}"; run; ods rtf close; ods trace off; ods listing; ... View more

This paper describes exactly what you need. http://www2.sas.com/proceedings/sugi31/177-31.pdf And a bit simpler code: Subscript or Superscript in the footers/titles of RTF output | StudySAS Blog Good luck! Anca ... View more

Hi Nicholas. This is what I figured out so far: ____________________________________________________________________ *this is the code that produces your desired plot; proc sort data = sashelp.class out = t;by sex; ods graphics on; proc boxplot data = t; plot age*sex /boxstyle=skeletal                         nohlabel boxconnect=q3                         cconnect=blue boxwidthscale=1 clipfactor=1.5 clipsymbol=dot;                         insetgroup n; run;quit; ____________________________________________________________________ OK, so in order to keep the nice features that ODS Graphics provides, but to remove the title, I think you may need to change from PROC BOXPLOT to PROC TEMPLATE + PROC SGRENDER. So, the one way I figured how to remove the title is by "defining" your own template where you don't use the "ENTRYTITLE" statement (See below, please): proc template; define statgraph PrettyBox; begingraph;     *entrytitle 'Distribution of Age by Sex';*<----This statement makes your title appear, by default, when you use the ODS GRAPHICS;         layout overlay;             boxplot y=age x=sex;         endlayout; endgraph; end; run; proc sort data=sashelp.class out=class;by sex;run; proc sgrender data=class template=PrettyBox; run; However, you will need to read about how to "enhance" the graph template definition (which I called "prettyBox") to add the Ns, and the different widths, and all these other things that we both know how to do in PROC BOXPLOT. OK. I may return if I come up with a better answer. :smileyconfused: ... View more

Hi. I am not sure what's wrong with the code, but it seems to me that this SQL part will never be anything but zero, because in the Rcrds data set - the way you have it as an example - var1 will never be equal to ' || var1 ||' var1 in the data set is A, A,C, or E. Call EXECUTE('proc sql noprint;            select compress(put(count(*),8.)) into:cn                 from Rcrds                 where var1="'|| var1 ||'";'); So, you need to modify that, some what. Best of luck, Anca. ... View more