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: 
VCM
‎07-20-2023
  • 23 Posts
  • 0 Likes Given
  • 0 Solutions
  • 4 Likes Received

SGPLOT swimlane with different symbols at same timepoint

by Obsidian | Level 7 in Graphics Programming
‎09-04-2018 04:10 PM
‎09-04-2018 04:10 PM
Asking for a co-worker (no, really I am!)  so I don't have specific code (I'm not on his project...)   He is making a swimlane plot with subject ID on the y-axis and timepoint on the x-axis.  There are only a few subjects, so the bars are "thick" to fill up some space.   On these bars he is placing 2 symbols--X and a square--representing events that are not necessarily related, using scatterplot.  However, we have subjects for whom these 2 events happened at the same timepoint:     Subject #2 shows how these symbols actually print--the two of them overlay each other.  However, the client wants it displayed like subject #1, with the symbols stacked.      Any ideas?     Many thanks! VCM ... View more

Need a 2nd headline when using spanning header

by Obsidian | Level 7 in ODS and Base Reporting
‎06-21-2018 10:54 AM
‎06-21-2018 10:54 AM
I need to create a report with spanning headers over the columns, then a line below the spanning headers, then the "main" headers, and then another line:     Using HEADLINE gives me the bottom line, of course, but is there a fast and easy way to create the first line, besides literally typing in a bunch of underscores?     VCM   ... View more

Re: Fast/Easy way to display Geometric Mean in a boxplot?

by Obsidian | Level 7 in ODS and Base Reporting
‎04-04-2018 04:19 AM
2 Likes
‎04-04-2018 04:19 AM
2 Likes
I was able to get this by suppressing the mean in the box, and adding a scatterplot statement to plot the geometric mean (which had been calculated earlier in the program): boxplot x=xvar y=yvar /whiskerattrs=(thickness=0) display=(fill median outliers); scatterplot x=xvar y=gmean/MARKERATTRS=(SIZE=6pt color=cx0066ff SYMBOL=trianglefilled); ... View more

Re: Fast/Easy way to display Geometric Mean in a boxplot?

by Obsidian | Level 7 in ODS and Base Reporting
‎03-29-2018 12:03 PM
2 Likes
‎03-29-2018 12:03 PM
2 Likes
I think the geo mean is the exp of the mean of the log, so I don't think just creating new variable = log(yvar) and then running it through the sgrender will work. (Someone correct me if I'm wrong?) VCM ... View more

Fast/Easy way to display Geometric Mean in a boxplot?

by Obsidian | Level 7 in ODS and Base Reporting
‎03-29-2018 11:38 AM
‎03-29-2018 11:38 AM
I have inherited a general boxplot program (V9.4) that displays the mean.  I need to update to reporting the geometric mean.   The current program is using a boxplot statement in PROC TEMPLATE, which is then called in PROC SGRENDER:   proc template; define statgraph XXX; begingraph ; ...blah blah axis options and titles and whatnot... boxplot y=yvar x=xvar / datalabelattrs=(color=black size=4) boxwidth=0.25 display=(caps fill median mean outliers); endlayout; endgraph; end; run; proc sgrender data=mydata template = XXX; run; quit;   I'm not finding any options to display geometric means.  I'm poking around at using PROC SGPLOT instead with VBOX, but I'm not finding any options there either.   Unless there is some awesomely cool proc or option I'm missing, I'm thinking my best bet may be to suppress printing the mean, calculate geo-mean, and overlay it separately.  Any suggestions?     Many many thanks, VCM  ... View more

Re: Forcing alignment of numeric-turned-character variables

by Obsidian | Level 7 in SAS Programming
‎02-15-2018 10:23 AM
‎02-15-2018 10:23 AM
That's why I added STRIPPUT3 = strip(PUT3); LEN = length(STRIPPUT3); You can see in the original post that STRIPPUT3 does left-align and the lengths are correct. But when I add 2 leading blanks to "3" and one leading blank to "82", you can see it still doesn't align correctly. ... View more

Re: Forcing alignment of numeric-turned-character variables

by Obsidian | Level 7 in SAS Programming
‎02-15-2018 10:15 AM
‎02-15-2018 10:15 AM
Thanks, but I'm not worried about the numbers in parentheses; I need to align the 3-digit/character number in front of the parentheses. ... View more

Re: Forcing alignment of numeric-turned-character variables

by Obsidian | Level 7 in SAS Programming
‎02-15-2018 10:13 AM
‎02-15-2018 10:13 AM
I'm not trying to align the numbers within the parentheses--those are coming out fine.  I'm trying to align the numbers in front of the parentheses.     I thought that if you put(number,format.) to create a character variable, it would automatically left-align it (then all I would have to do is add leading blanks where needed), but that doesn't seem to be the case.     ... View more

Re: Forcing alignment of numeric-turned-character variables

by Obsidian | Level 7 in SAS Programming
‎02-15-2018 08:21 AM
‎02-15-2018 08:21 AM
These didn't work; the alignment of the characters in ADDBLANKS is still the same as above. 😞 ... View more

Forcing alignment of numeric-turned-character variables

by Obsidian | Level 7 in SAS Programming
‎02-15-2018 07:59 AM
‎02-15-2018 07:59 AM
I'm creating a table with counts + percentages in this format:  nnn (nnn.n)   I want them to line up like this; numbers are made up, so no digs at my math skills ;-):     The percentages in the parentheses are coming out fine, but I can't force the counts (before the parentheses) to align properly once I change them to character.     C1 is the original numeric variable. PUT3 = put(C1,3.); STRIPPUT3 = strip(PUT3); LEN = length(STRIPPUT3); if LEN = 1 then addblanks = "  "||compress(stripput3); **2 blanks added in front**; if LEN = 2 then addblanks = " "||compress(stripput3);  **1 blank added in front**; if LEN = 3 then addblanks = compress(stripput3);   Even adding leading blanks doesn't align the character values the way the numeric values are.  Similar logic applied to the percentages works beautifully.   This is driving me nuts; what am I missing?  (Disclaimer:  I have not had my coffee yet.)     VCM ... View more

Re: Is REFERENCELINE valid with PROC SGRENDER?

by Obsidian | Level 7 in Graphics Programming
‎02-05-2018 10:55 AM
‎02-05-2018 10:55 AM
That was the ticket, thank you so much! 🙂 ... View more

Re: Is REFERENCELINE valid with PROC SGRENDER?

by Obsidian | Level 7 in Graphics Programming
‎02-05-2018 10:55 AM
‎02-05-2018 10:55 AM
Brilliant, worked perfectly! Thank you so much! 🙂 ... View more

Is REFERENCELINE valid with PROC SGRENDER?

by Obsidian | Level 7 in Graphics Programming
‎02-05-2018 10:49 AM
‎02-05-2018 10:49 AM
I have a scatterplot that needs a diagonal reference line (from 1,1 to MAXx,MAXy).     My proc template:   proc template; define statgraph XXXX; begingraph ; layout overlay / xaxisopts = (label='x-axis label' labelattrs=(family="Courier New" size=8pt weight=bold) tickvalueattrs=(family="Courier New" size=8pt weight=bold) linearopts = (tickvaluesequence = (start = 1 end = 10 increment = 1) viewmin = 1 viewmax = 10)) yaxisopts = (label="y-axis label" tickvalueattrs=(family="Courier New" size=8pt weight=bold) linearopts = (tickvaluesequence = (start = -10 end = 15 increment = 5) viewmin = -10 viewmax = 15)); entry halign=left ' ' / valign=top textattrs=(family="Courier New" size=8pt weight=bold);   scatterplot x = pwk1 y = awk1 / markerattrs = (color=red symbol=circlefilled size=5) name="trt1" legendlabel="Avelumab"; scatterplot x = pwk2 y = awk2 / markerattrs = (color=blue symbol=circlefilled size=5) name="trt2" legendlabel="Avelumab + PLD"; scatterplot x = pwk3 y = awk3 / markerattrs = (color=green symbol=circlefilled size=5) name="trt3" legendlabel="PLD"; discretelegend "trt1" "trt2" "trt3"/ across=1 valueattrs=(family="Courier New" size=8pt weight=bold) valign=bottom halign=center location=outside;   endlayout; endgraph; end; run; proc sgrender data=final template = xxxx; run; quit;   Can I use REFERENCELINE?  I've tried, but not sure if I'm not doing it correctly, or if it's not possible to use this statement.      Thanks! VCM ... View more

Re: Text rows uneven in forest plot

by Obsidian | Level 7 in Graphics Programming
‎12-21-2017 04:10 PM
‎12-21-2017 04:10 PM
Thanks, everyone--I was out yesterday so one of our plot gurus was called in to look at it.  Her solution:  make the dots smaller.  The size was knocking everything else out of whack.   But you have given me a lot of food for thought if I ever run into a similar situation where dot size doesn't help. 🙂 ... View more

Text rows uneven in forest plot

by Obsidian | Level 7 in Graphics Programming
‎12-19-2017 08:44 PM
‎12-19-2017 08:44 PM
I'm working on a forest plot with several columns of associated data.  The alignment is slightly off:     Note that in the first row, the p-val is slightly lower than the HR/CI.  By the last row, the p-val sits higher than the HR/CI.   Code for the text columns from proc template:   layout overlay / xaxisopts=(display=none) yaxisopts=(reverse=true display=none) walldisplay=none; scatterplot x=dummy y=ord / markercharacter=hr_ci; endlayout; *** overlay - Hazard Ratio/CI column***; layout overlay / xaxisopts=(display=none) yaxisopts=(reverse=true display=none) walldisplay=none; scatterplot x=dummy y=ord / markercharacter=pval; endlayout; *** overlay - p-value column ***; Dummy is, as the name implies, a dummy value (= 1 for every record).  Ord is the numeric order of the rows.  The markercharacters hr_ci and pval are the character results you see above.   Is there any way to "straighten out" the row alignment? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-20-2023 10:19 AM
Group Hubs for VCM
View All
Likes from
View All
Quick links