topic Re: plot with one bare based on a value in New SAS User

plot with one bare based on a value

mmea — Wed, 27 Jan 2021 18:19:45 GMT

Hi I have a value for example 0,80 on a date 27/01/2021

I want a plot showing only one bar with the date 27/01/2021 and with a percentage scale, so this bar will reach 80%. The bar should also contain a label "80 %" inside the bar

how can I do so?

Re: plot with one bare based on a value

PeterClemmensen — Wed, 27 Jan 2021 18:23:36 GMT

Try the VBARPARM Statement 🙂

Provide sample data if you want a full code answer.

Re: plot with one bare based on a value

mmea — Wed, 27 Jan 2021 18:28:40 GMT

proc sql;
 select distinct wanted_sum into :nobs
 from sumtable_0;
quit;

%put nobs=&nobs; 


**second value;

proc sql;
 select distinct wanted_sum into :kobs
 from sumtable_1;
quit;

%put kobs=&kobs; 

**calculation;

&kobs/&nobs

I made this macro where I get two different values everyday from my dataset fx in this case the wanted_sum from sumtable_0 is 4559099 and from sumtable_1 it is 3578989

everyday new numbers appears - these are from today.

then i divide them 3578989/4559099

the result of this should be the one bar plot in percentage.

Re: plot with one bare based on a value

PeterClemmensen — Wed, 27 Jan 2021 18:32:44 GMT

I'm not sure I understand. You have a single value 0.8 that you want in a bar chart? That bar chart would have one bar only?

Re: plot with one bare based on a value

mmea — Wed, 27 Jan 2021 18:37:36 GMT

Yes only one bar.

date = today()

and y axis should be from 0 to 100%

Also a label in the bar with the number of percentages it is in this case 80%

Re: plot with one bare based on a value

PeterClemmensen — Wed, 27 Jan 2021 19:10:55 GMT

See if you can use this as a template.

data plot;
   x = today();
   y = .8;
run;

proc sgplot data = plot;
   vbarparm category = x response = y / datalabel datalabelattrs = (size = 20);
   yaxis min = 0 max = 1;
   format x date9. y percent.;
   xaxis display = (nolabel);
   yaxis display = (nolabel);
run;

Re: plot with one bare based on a value

mmea — Thu, 28 Jan 2021 09:16:04 GMT

Thank you so much!

I got one bar - the bare is very big - is it possible to adjust the size of a bar in the width?

Re: plot with one bare based on a value

PeterClemmensen — Thu, 28 Jan 2021 09:38:59 GMT

Sure. Use the Barwidth Option on the VBARPARM Statement.

data plot;
   x = today();
   y = .8;
run;

proc sgplot data = plot;
   vbarparm category = x response = y / datalabel datalabelattrs = (size = 20) barwidth=.2;
   yaxis min = 0 max = 1;
   format x date9. y percent.;
   xaxis display = (nolabel);
   yaxis display = (nolabel);
run;

Result:

Re: plot with one bare based on a value

mmea — Thu, 28 Jan 2021 15:31:14 GMT

Can i make the y-axis go up to 100%

Re: plot with one bare based on a value

Rick_SAS — Thu, 28 Jan 2021 15:40:01 GMT

Of course. Here is the documentation for the SGPLOT procedure.

You can control the axes by using the XAXIS (horizontal axis) and YAXIS statements (vertical). Look at the MIN= and MAX= options on the YAXIS statement.

Re: plot with one bare based on a value

mmea — Thu, 28 Jan 2021 16:08:26 GMT

proc sgplot data = plot;
   vbarparm category = x response = y / datalabel datalabelattrs = (size = 10)barwidth=.2;
   yaxis min = 0 max = 1;
   format x date9. y percent.;
   xaxis display = (nolabel);
   yaxis display = (nolabel);
   Title1 font = 'Calibri' height=16pt "Ande";
run;

it does not work - can you help

Re: plot with one bare based on a value

Rick_SAS — Thu, 28 Jan 2021 16:28:41 GMT

proc sgplot data = plot;
   vbarparm category = x response = y / datalabel datalabelattrs = (size = 10)barwidth=.2;
   format x date9. y percent.;
   xaxis display = (nolabel);
   yaxis display = (nolabel) MAX=1;
   Title1 font = 'Calibri' height=16pt "Ande";
run;