Hi,    I was curious to see if there was a procedure that regroups variables in a meaningful, statistically sound way.   I have a variable with 10 different levels that I would like to reduce to 5 levels. I can regroup on my own but wanted to see if there was a faster, more sophisticated way of doing so.   Help is greatly appreciated! ... View more

SAS base 9.4 I want to make a grouped bar chart using sgplot vbarparm that looks like the one attached (see attachment) but with error bars. Does anyone have code for this?  My main goal is to get multiple variables on the x axis and display their different levels without having to have a legend. Thank you!   This is the code I have created for a different bar chart, feel free to make modifications to it in order to create the desired bar chart. proc sgplot data=state noborder ; format percent f8.1 state state.; where state>0 and percent>0;   STYLEATTRS DATACOLORS=(cxcccccc cx99CCFF cx99CCFF cx99CCFF cx99CCFF cx99CCFF cx99CCFF); vbarparm category=state response=percent / group=state groupdisplay=cluster   barwidth=0.8 nooutline; xaxis display=(nolabel noticks noline ) VALUEATTRS=(size=9 ); yaxis label='Percent' grid values=(0 to 50 by 10) display=(noticks noline) VALUEATTRS=(size=9 ); run; ... View more

I am trying to create categories from open ended questions.  What is the best way to go about this if I want to use full strings?  Is there a way to do this without identifying position or case e.g (lowercase)?  I have attached code so you guys can get an idea of what I am trying to do, I am sure the index function probably is not the best way to go about this.  I basically want to tell say, " if a response in var contains this word and/or string, then var=1 ..." SAS base 9.4 ... View more

SAS v 9.3 I am trying to generate a simple sgplot with percentages.  I want to be able to add multiple variables on the vbar statement but that is not an option. I have I am also having trouble creating a data set from my proc freq that includes ALL of my variables.  data work.ins15; set ins.ins15; run;   proc freq data=work.ins15; tables cig ecig chew / plots=FreqPlot(scale=Percent) out=Freq1Out; /* save Percent variable */ weight _cpwt; where cig=1 and ecig=1 and chew=1; run; data Freq1Out; set Freq1Out ; Percent = Percent / 100; /* adjust range to [0, 1] */ format Percent PERCENT5.; run; title ""; proc sgplot data=Freq1Out noborder; vbar cig / response=Percent datalabel fillattrs=(color=blue); /* axis shows percentages instead of counts */ xaxis display=(nolabel); yaxis display=(nolabel) ; run; ... View more

I have SAS 9.4 and I am trying to generate multiple graphs from a proc template using: ods _all_ close; ods graphics on / reset=all width=6.0in height=3.5in noborder IMAGEFMT=EMFdual noscale ; ods html close ; ods printer printer=emfdual; options nodate nonumber printerpath=emfdual; filename output "d:\data\&var.emf";     This will only output the first observation of my macro and it completely ignores my output destination.  I have tried other options and most of them appear to generate emf output but they are really PNGs. Any suggestions ?  Thanks! ... View more

This is my first time dealing with annotation. I have decided to utilize annotation because I will be generating several graphs and I want to be sure I don't have issues with my error bars running into my labels.  Ideally, I would like my labels to be located inside the bars at the base of each bar. I am trying to insert labels (data labels) into my proc template barchartparm.  Is it possible to do this with drawtext if i am using values of a variable for my bar labels ?   proc template; define statgraph district; begingraph / datacolors=(white CXEBDDED CXEBDDED CXEBDDED CXEBDDED CXEBDDED CXEBDDED CXEBDDED) ; layout overlay / walldisplay=(fill) xaxisopts=(display=( line tickvalues) DISCRETEOPTS=(TICKVALUEFITPOLICY =split)) yaxisopts=( offsetmin=0 linearopts=(viewmin=0 viewmax=100 tickvaluelist=(0 50 100))); /* drawtext textattrs=(size=8pt) "variable" /width=5 widthunit=percent xspace=datavalue yspace=graphpercent x=2*/ /* y=80 justify=center;*/ barchartparm x=district y=percent / group=district groupdisplay=cluster errorupper=uppct errorlower=lowpct ERRORBARATTRS=(color=black) OUTLINEATTRS=(color=black) ; /* scatterplot y=percent x=district / datalabel=percent */ /*DATALABELPOSITION=topright DATALABELATTRS=GRAPHVALUETEXT(SIZE=10pt weight=bold) markerattrs=(size=0) ;*/ annotate; endlayout; endgraph; end; run; proc sgrender data=district template=district sganno=anno; format district district.; run;   the following code inserts "variable" into my graph.  I want it to insert percent values from my variable. drawtext textattrs=(size=8pt) "variable" /width=5 widthunit=percent xspace=datavalue yspace=graphpercent x=2  y=80 justify=center;   I have also tried using an annotated data set which gave me the following error.  NOTE: FUNCTION=label in the annotation data set is invalid. Code: data anno; length function color text $ 8; retain function 'label' color 'black' when 'a' xsys ysys '2' position '2' size 3 hsys '3'; set district; midpoint=&VAR.; group=district; function='label'; xsys='2'; ysys='2'; x=midpoint; y=0; text=left(put(percent,4.1)); size=5; output; run;   Can anyone tell me the best way to go about doing this?  Thanks!   ... View more