cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ChristosK
‎09-19-2020
  • 141 Posts
  • 28 Likes Given
  • 0 Solutions
  • 2 Likes Received

Non breaking spaces and formatting for gaps on an axis

by Quartz | Level 8 in ODS and Base Reporting
‎03-07-2018 01:28 PM
‎03-07-2018 01:28 PM
Ive had some inconsistency in applying formatting to the internal, values within a categorical variable that I want to place on an x axis in proc sgplot. Previous we were discussing how to create non breaking spaces as suggested by : https://blogs.sas.com/content/graphicallyspeaking/2017/10/16/tips-tricks-multiple-blank-categories-axis/   I must be doing something wrong in my formatting as every approach I have tried does not implement the required new formats consistently, and we are no getting blank non breaking spaces.   My code and datasets were previously shared and would be happy to share again,   Thanks,   Christos  ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-26-2018 02:31 PM
‎02-26-2018 02:31 PM
  OK, so here is what I tried too do. Relevant code in red, attachments demonstrate the output, and what is going wrong....     proc format; value $Namefmt "Age" ="Age" ..........etc.... "A" ="." "B" ="." "C" ="." ; run;     proc template; define style mystyle; parent=styles.sasweb; class graphwalls / frameborder=off; class graphbackground / color=white; end; run; ods listing close; ods html style=mystyle path='.' file='newgraph.html'; ods graphics / reset=all border=off width=800 height=900; proc sgplot data = HEERDT.Vasoplegia_space nowall noborder ; Title "OR (95% CI) for covariates across Vasoplegia Severity" ; styleattrs datacontrastcolors=(CX18577A CX30CC6E ) ; scatter x=sdOR y=Name / xerrorupper=sdUCL xerrorlower=sdLCL noerrorcaps markerattrs=(symbol=circlefilled size =5 ) group=Severity groupdisplay=cluster clusterwidth=0.6; yaxis DISCRETEORDER= DATA reverse valueformat= $Namefmt.; xaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal)type =log logbase =10; yaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal) valueshalign=left colorbands=odd colorbandsattrs=(transparency=0.7); refline 1.0 / axis=x discretethickness=1 lineattrs=(color=cxd0e0f0); yaxistable pdp2_char sdORCI /class =Severity classdisplay =stack position=right location=outside VALUEATTRS=(Color=Black Family=Arial Size=8 Weight=Normal ) VALUEHALIGN=CENTER VALUEJUSTIFY= CENTER CLASSORDER=DATA COLORGROUP=Severity; xaxis display=(nolabel) values=(0.4 1.0 1.5 2.0 2.5 5 6); run;     ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-26-2018 02:01 PM
‎02-26-2018 02:01 PM
Sanjay:   Sorry about the late response. I have been trying to make this work, but am not able to get rid of the spaces yet on the categorical axis . Maybe its an error that Im doing in formatting ?   I never did see how you can change the order of the columns though. I wanted to have two columns of p values and two for OR (CI), but to have the "Mild:" response first, and then the p columns  and OR(CI) for the "Severe Response).     ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-20-2018 09:41 PM
‎02-20-2018 09:41 PM
OMG.   Sorry about that!  Thats pretty embarrassing, here is the right database. Have looked at the full code at the link you forwarded, but still unsure how to make subgroups. Will have to percolate on this overnight. How can you create a space between potential subgroups? ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-20-2018 08:35 PM
‎02-20-2018 08:35 PM
Here is the SAS database. I've done most things, except:   1) Create a space between sets of clinical variables. (eg preoperative conditions should be separated from bypass time, volume of blood products etc.)   2) Possibly changing the shading so sets of variables are all shaded o e colour.   3) Place a subtitle above and slightly indented to the left of each of these sets.   4) p values in table for severe should be next to their OR (CI), not alternately.  I would probably remove the table lable colours.   Thanks,   Christos ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-20-2018 08:30 PM
‎02-20-2018 08:30 PM
Here is the latest code I used and the output. Have made some progress. How do you change the order of the table columns so the p values for mild and severe end up adjacent to their respective. Ors (CI)? Will send the database in the next message .       proc template; define style mystyle; parent=styles.sasweb; class graphwalls / frameborder=off; class graphbackground / color=white; end; run; ods listing close; ods html style=mystyle path='.' file='newgraph.html'; ods graphics / reset=all border=off width=800 height=900; /* sd OR's */ proc sgplot data =HEERDT.VP_Table2b2 nowall noborder ; Title "OR (95% CI) for covariates across Vasoplegia Severity" ; styleattrs datacontrastcolors=(CX18577A CX30CC6E ) ; scatter x=sdOR y=Name / xerrorupper=sdUCL xerrorlower=sdLCL noerrorcaps markerattrs=(symbol=circlefilled size =5 ) group=Severity groupdisplay=cluster clusterwidth=0.6; yaxis DISCRETEORDER= DATA reverse ; xaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal)type =log logbase =10; yaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal) valueshalign=left colorbands=odd colorbandsattrs=(transparency=0.7); refline 1.0 / axis=x discretethickness=1 lineattrs=(color=cxd0e0f0); yaxistable pdp2_char sdORCI /class =Severity classdisplay =stack position=right location=outside VALUEATTRS=(Color=Black Family=Arial Size=8 Weight=Normal ) VALUEHALIGN=CENTER VALUEJUSTIFY= CENTER CLASSORDER=DATA COLORGROUP=Severity; xaxis display=(nolabel) values=(0.4 1.0 1.5 2.0 2.5 5 6); run; ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-20-2018 06:34 PM
‎02-20-2018 06:34 PM
Thank you Sanjay.   Initially it seemed as though I would only be able to chart 95% CI's for the OR by using a scatter command , but it looks like HBOX is able to do this automatically. My OR and CI's are values that I have calculated from the study database and recorded in a secondary database, so OR is not a continuous variable that I can plot with the choices that "seem" to be available for HBAR and DOT.   Scatter has "scatter x=OR y=Vp / xerrorupper=UCL xerrorlower=LCL", so plotting those is easy enough. I cant see how to do this in HBAR and DOT.   If I have groups pdf variables that are "clustered" in terms of clinical significance, is there a way to create a space between the groups, or to have them indented (but starting from a left margin), with a subheading in the row above and indented more to the left?       ... View more

Re: reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-18-2018 08:42 PM
‎02-18-2018 08:42 PM
Thank you Sanjay: Yes, I did try that after Iooked at : http://support.sas.com/documentation/cdl/en/grstatproc/65235/HTML/default/viewer.htm#n0n6uml63c6h8dn16phbd1arm9g9.htm   DISCRETEORDER= DATA | FORMATTED | UNFORMATTEDspecifies the order in which discrete tick values are placed on the axis. Specify one of the following values: DATA places the values in the order in which they appear in the data. FORMATTED sorts the formatted values in ascending character order. UNFORMATTED sorts the unformatted values in ascending character order. Default:UNFORMATTED Restriction:This option affects only box plots, dot plots, bar charts, and line plots, or for any axis where TYPE=DISCRETE.     I specifically wanted to reverse the direction, as the Y axis had these discrete values plotted from the bottom upwards, which is different in orientation to the order in the dataset. I tried applying a "reverse" statement here but this didn't work.  I also created an additional ordinal numeric ID variable and used proc sort,  so the order was reversed in the SAS dataset; Even though the order was reversed by proc sort, the graph still came out the same.   Only thing that worked was reversing the order in an Excel version of this dataset.   So.... is there not a way in SAS to plot a categorical axis in reverse orientation, but maintaining the same order? In this case maintaining the order had clinical importance.   Thanks,   Christos   ... View more

reversing order of character variable in sgplot

by Quartz | Level 8 in Graphics Programming
‎02-18-2018 01:17 PM
‎02-18-2018 01:17 PM
I have a character variable on the y axis, and need to reverse the order. I created a new numeric ordinal  id variable in the excel version of the dataset, imported it to SAS, and reversed the order with proc sort. It looked fine in proc print but in proc sgplot we did not have the desired order of the discrete variables.   Any ideas?   Also, if I want to use sgpanel, and have two variations of these figures side by side (1 row, 2 columns), how to I arrange for a y axis table to be on the right of each figure? Would also like to only label one of the y axes?     ... View more

Re: proc sgplot, Title and Xaxis table output

by Quartz | Level 8 in Graphics Programming
‎02-17-2018 10:08 PM
‎02-17-2018 10:08 PM
Usually I press on the pdf "download results as a pdf file" button in the results window, between the RTF and word buttons. It may be because this is a locked down version, although I thought it unlikely at first since the font in results is as I specified  .   However....I did try this just before the proc sgpolot data line after creating a file on my desktop to save pdf files in. ods pdf file ="/Users/Desktop/My SAS PDF Files"; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 ods pdf file ="/Users/Desktop/My SAS PDF Files"; ERROR: Unable to open filename /Users/christoskoutentis/Desktop/My SAS PDF Files. ODS PDF initialization fails. ERROR: The path /Users/christoskoutentis/Desktop/My SAS PDF Files is not in the list of accessible paths when SAS is in the lockdown state.   At least we now know more about whet cant be done in sas studio.   Any idea about getting axis tables in proc sgpanel? I found a colaxis tableoption, but its not what the same as we have in procsgplot. Also, still cant reverse the border or the variables on the Y axis (it is discrete), and I would like to align them on the left. of possible. Lastly, can I change the alignment of the numbers in the axis tables? Ideally I would like to have the confidence intervals in brackets separated by a comma rather than a column for each values. I guess I can put those numbers with brackets etc and use that as a character variable.   ... View more

Re: proc sgplot, Title and Xaxis table output

by Quartz | Level 8 in Graphics Programming
‎02-17-2018 07:31 PM
‎02-17-2018 07:31 PM
Looks like we have the same issue with the bold font in the last column of the table I just uploaded.  Only seems to happen when I save to PDF, even though it looks OK in the output. ... View more

Re: proc sgplot, Title and Xaxis table output

by Quartz | Level 8 in Graphics Programming
‎02-17-2018 07:17 PM
‎02-17-2018 07:17 PM
Thats fine, but is there anything I can do about the table font changing when I save it as a PDF? ... View more

proc sgplot, reversing order of discrete Y axis.

by Quartz | Level 8 in Graphics Programming
‎02-17-2018 07:16 PM
‎02-17-2018 07:16 PM
Along similar lines:   I have a new figure / table:   Y axis is discrete. I want the order to be the reverse of what we have now. Looked at  http://documentation.sas.com/?docsetId=grstatproc&docsetTarget=n0n6uml63c6h8dn16phbd1arm9g9.htm&docsetVersion=9.4&locale=en#p1w9lby6swr7qkn1c3nw5657ctw5   This is all I can see that is relevant:   DISCRETEORDER=DATA | FORMATTED | UNFORMATTED specifies the order in which discrete tick values are placed on the axis. This option affects any plot with a discrete axis. Specify one of the following values: DATA places the values in the order in which they appear in the data. Note: This value is not supported with CAS data. FORMATTED sorts the formatted values in ascending character order. UNFORMATTED sorts the unformatted values in ascending character order. Default UNFORMATTED       Is there anything I can do to reverse this order?     proc sgplot data =VP_Table2b2 (where=(Severity ="Severe"))nowall noborder ; Title "OR (95% CI for covariates across Vasoplegia Severity" Font=Arial color=black; scatter x=OR y=Name / xerrorupper=UCL xerrorlower=LCL noerrorcaps markerattrs=(symbol=circlefilled size =5 ) ; yaxis type =discrete reverse; xaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal)type =log logbase =e; yaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal); refline 1.0 / axis=x discretethickness=1 lineattrs=(color=cxd0e0f0); yaxistable pdp2_char ORr LCLr UCLr / location=outside VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Italic Weight=Normal); run; ... View more

proc sgplot, Title and Xaxis table output

by Quartz | Level 8 in Graphics Programming
‎02-16-2018 08:52 PM
‎02-16-2018 08:52 PM
Using SAS University Edition:   1) Trying to specify font, etc in Title , but getting the error message below  saying that Arial, etc is not available. Error message in green below. I coloured the code in red.   2) Xaxis table: It looks fine in the output, or when I save it to HTML, although when I save to PDF, the bottom line is bold, and all the italics are in Normal style. Two screenshots are enclosed to show the difference.       Should I be doing something else in proc template or do I need to use a macro to add fonts? proc template; define style mystyle; parent=styles.sasweb; class graphwalls / frameborder=off; class graphbackground / color=white; end; run; ods listing close; ods html style=mystyle path='.' file='newgraph.html'; ods graphics / reset=all border=off width=640 height=480;   proc sgplot data =Heerdt.VPPlotsforSAS1 (where=(level=2)) nowall noborder ; Title "OR (95% upper CI) for composite estimate of Severe Vasoplegia over 24h (shaded), and at specified times up to 24 hours, by preoperative blood pressures" Font=Arial color=black; styleattrs datacontrastcolors=(CX18577A CX30CC6E CX666666 CXFFA700 ) ; scatter x=Vp y=OR / yerrorupper=UCL yerrorlower=LCL group=Blood_Pressure1 groupdisplay=cluster clusterwidth=0.6 noerrorcaps markerattrs=(symbol=circlefilled size =5 ) ; xaxis type =discrete; xaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal); yaxis display =(noticks nolabel noline) VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Normal Weight=Normal); refline 1.0 / axis=y discretethickness=1 lineattrs=(color=cxd0e0f0); refline "24h" / axis =x discretethickness=1 transparency=0.8 lineattrs=(color=cxd0e0f0); xaxistable total_char c2_char missing_char / location=outside VALUEATTRS=(Color=Black Family=Arial Size=8 Style=Italic Weight=Normal); keylegend /valueattrs=(size=10) title ="Blood Pressure" location =inside position=bottomright noborder down=1 title =""; run;       WARNING: The font <sans-serif> is not available. Albany AMT will be used. WARNING: Unable to use the Albany AMT font. The font might not be registered or more memory is needed. WARNING: Unable to use the Albany AMT font. The font might not be registered or more memory is needed.   ... View more

Re: proc sgplot, plotting OR's and CI

by Quartz | Level 8 in SAS Programming
‎02-14-2018 02:02 PM
‎02-14-2018 02:02 PM
Thanks Reeza, this is fantastic! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-19-2020 03:15 PM
Likes given to
Likes from
View All
Quick links