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: 
ramtejdasari
‎04-12-2021
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to suppress the duplicate legend values in keylegend statement...

by Super User in SAS Programming
‎04-06-2021 11:10 PM
‎04-06-2021 11:10 PM
Maybe give the plots that you want to include in the legend a name and then only include those in the key legend instead?   FYI - this is a case where formatting the code for legibility really helps. Your exclude statement confuses me as there's no other reference to that item in the code.....   @ramtejdasari wrote: Hi , I am creating waterfall plot and a bar chart in one panel ,  where in both the plots the treatments are same for the legend. I don't want to duplicate the same treatments for the two plots in the legend. How can i suppress or exclude the duplicate treatments from the legend.  I am using below code to create the plots. Attached is the plot for reference     proc sgplot data=fin nowall noborder nocycleattrs; format trtpn arm.; styleattrs datacolors=(blue yellow green red purple) datacontrastcolors=(blue yellow green red purple) axisextent=data; symbolchar name=mystar char='002a'x / voffset= -0.5 scale=7; vbarparm category=usubjid response=chgsld / group=trtpn datalabel=chgsld dataskin=pressed datalabelattrs=(size=8 weight=bold) clusterwidth=1; vbarparm category=usubjid response=chgbm / group=trtpn datalabel=chgbm y2axis dataskin=pressed /*fillattrs=(color= cxcfcf7f)*/; scatter x=usubjid y=CRR / markerattrs=(symbol=mystar color= green size=3); /* refline 20 -30 / lineattrs=(pattern=shortdash);*/ xaxis display=none colorbands=odd colorbandsattrs=(transparency=0.6); yaxis label="Change from baseline in Total SLEDAI score" values=(40 to -40 by -10) offsetmax=0.55 labelpos=datacenter offsetmin=0; y2axis label="Change from baseline in Biomarker" values=(90 to -90 by -15) offsetmin=0.5 offsetmax=0.02 labelpos=datacenter; keylegend / exclude=("Change from Baseline") title='' border; run;   ... View more

Re: how to add asterisk to the values in the output

by Diamond | Level 26 in SAS Programming
‎01-12-2021 08:58 PM
‎01-12-2021 08:58 PM
Hi: Without seeing ALL of your code and having some test data, it is impossible to make a constructive comment. The one thing that I can think might cause the behavior you describe, is if you might have an ACROSS variable on your report? If so, then a simple format won't work in that case. You'll have to use CALL DEFINE, as I showed in my last posted example, where I tested height and weight. But with an ACROSS item, the code gets a bit more complex. You'll have to use absolute column numbers in the CALL DEFINE. I could not open your PDF file because it got an error.   Here's an ACROSS example where I only want to add an asterisk for the WEIGHT value under the M Across column:   Here's a paper that talks more about using ACROSS items with PROC REPORT http://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf   . Of course, if I guessed wrong, then you'll need to explain in more detail providing code and data. Or work with Tech Support on this. Tech Support can look at ALL your data and ALL your code and answer your question. Cynthia ... View more

Re: How to write a code in this situation.

by Calcite | Level 5 in New SAS User
‎05-15-2019 05:42 PM
‎05-15-2019 05:42 PM
Hi Ballardw   we have a separate program like studyauto , where we created macro variables for study and srcdata.   I just tried the code by removing %str in the code and it works now.it is related to the &study variable in the studyauto program where we created this.   Again thank you so much for your valuable input. It resolved now. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-12-2021 11:44 AM
Quick links