I have some mean, n, and sd values, which I use to create a string.  The length of the string reaming the same in all conditions is important to me since I am adding another 'character based on the length of the string ( length in terms of visual). Is there any easy way to achieve this? Thank you for your input and suggestions. data have; input subjid n mean sd; cards; 01 . . . 02 1 1.2 . 03 10 2.4 1.15 04 1 1.4 0.05 05 15 110.4 10.05 06 1 110.4 . 07 100 110.4 12.35 08 100 8.5 12.35 09 10 108.5 100.35 ; run; * instruction: 1. if 'n' value missing then display value as '0' 2. if 'mean' or 'sd' missing then display the value ' ' ( based on the length to match string length) *~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ string1 = "n = XXX 'Total change in School in New York, Mean (SD): xxx.x (xxx.xx)" string2 = "n = XXX ' Total change in School in Maine, Mean (SD): xxx.x (xxx.xx)" The final string1 and string2 (79 characters including the blanks) length should be same for all the subjects, Insert the blanks where it needed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~; ... View more

 I am trying to achieve the Histogram like in the image ( sorry for my artistic abilities). Is it possible? Thank you for your input. In the following data, I want the count/ percentage based on the 'SEPALLENGTH' on the Y axis and X- the axis should have the  'cat.' (  1  in image) If not, then the customized scale ( like how it was done in the 'Univariate" code). with the histogram filled ( labeled with 'CAT') (2 in image). thank you for your help and suggestions. data iris; set sashelp.iris; if 40<=SepalLength<45 then cat = "40<= SL <45"; else if 45<=SepalLength<50 then cat = "45<= SL <50"; else if 50<=SepalLength<55 then cat = "50<= SL <55"; else if 55<=SepalLength<60 then cat = "55<= SL <60"; else if 60<=SepalLength<65 then cat = "60<= SL <65"; else if 65<=SepalLength<70 then cat = "65<= SL <70"; else if 70<=SepalLength<75 then cat = "70<= SL <75"; else if sepallength >= 75 then cat = ">= 75"; run; ** graphs by univariate**; proc univariate data=iris; class species; histogram sepallength / normal(color=blue) ctext = blue midpoints = 40 to 80 by 5; INSET N = 'Count' MEDIAN (8.2) MEAN (8.2) STD = 'Standard Deviation' (8.3)/ POSITION = ne; ; run; **************************; **graphs by SGPLOT **; proc means data=iris noprint; class species; var SepalLength; output out=meanval mean=; ways 1; run; data _null_; set meanval; if species = 'Setosa' then call symput("SE_Mean", put(SepalLength, best6.)); if species = 'Versicolor' then call symput("Ve_MEAN", put(SepalLength, best6.)); if species = 'Virginica' then call symput("vi_MEAN", put(SepalLength, best6.)); run; proc sgplot data=iris; by species; histogram SepalLength / group = species ; inset ( "Setosa"="&SE_Mean" "Versicolor"="&Ve_MEAN" 'Virginica'= "&vi_MEAN") / border title=" Species"; run;     ... View more

Please tell me if it's a stupid question.  I am looking to create a bubble graph. But I want to change the shape of the bubble. Is that possible? (this may be a stupid question sorry!); if it's not possible, is there any other alternative way. Thanks Code  Credits  :Sanjay Matange reference:  https://blogs.sas.com/content/graphicallyspeaking/files/2015/06/Bubble.txt %let gpath='.'; %let dpi=200; ods html close; ods listing gpath=&gpath image_dpi=&dpi; /*--Create Bubble Data--*/ /*--Areas of min and max bubble size is computed--*/ data bubble; format Area 4.1 size 2.0; format LinArea PropArea 4.0; pi=constant("pi"); input X Y Size Type $ Cat $; /*--Area of bubble with Size as redius--*/ Area=size*size*pi/4; /*--Min and max size of bubbles on screen and areas--*/ maxR=3*7; minR=7; MaxArea=maxR*maxR*pi; MinArea=minR*minR*pi; Max=15; Min=13; /*--Area of bubble using linear scaling--*/ LinArea= MinArea+(Size-Min)*(maxArea-minArea)/(Max-Min); /*--Area of bubble using Proportional scaling--*/ PropArea= Size*maxArea/max; LinLbl='ValueArea=' || put (area, 4.0) || '-PixelArea=' || put(LinArea, 4.1); PropLbl='ValueArea=' || put (area, 4.0) || '-PixelArea=' || put(PropArea, 4.1); datalines; 20 20 14 A X 50 10 13 B Y 80 60 15 A Z ; run; ods html; proc print;run; ods html close; ods path(prepend) work.templat(update); /*--Bubble Chart with Linear scaling--*/ ods graphics / reset attrpriority=color width=4in height=2.8in imagename='Bubble_Linear_SG'; /*--Bubble Chart with Proportional scaling--*/ proc template; define statgraph Bubble; begingraph; entrytitle 'Proportional Bubble Size - GTL'; ; layout overlay / aspectratio=0.7 xaxisopts=(display=(ticks tickvalues line) griddisplay=on linearopts=(viewmin=0 viewmax=100) offsetmin=0 offsetmax=0.1) yaxisopts=(display=(ticks tickvalues line) griddisplay=on linearopts=(viewmin=0 viewmax=70) offsetmin=0 offsetmax=0.1); bubbleplot x=x y=y size=size/ group=type datalabel=PropLbl relativescaletype=proportional datalabelsplit=true datalabelsplitchar='-' name='a' dataskin=sheen display=(fill); textplot x=x y=y text=size / position=center; endlayout; endgraph; end; run; /*--Bubble Chart with Proportional scaling--*/ ods graphics / reset width=4in height=2.8in imagename='Bubble_Prop_GTL'; proc sgrender data=bubble template=bubble; run; ... View more

I have the following number in character format. How Can I change that into the numeric form, including spaces? Is that possible? '012932 01 001' ... View more