topic Re: How to add number of observations to an SGplot? in SAS Programming

How to add number of observations to an SGplot?

EC27556 — Mon, 21 Jun 2021 18:42:48 GMT

Hi, how can you add the number of observations used in an sgplot to a graph. I.e. for the below code, somewhere on the graph, or as a title if easier, I would like it to say "428 observations").

Ideally I'd like something that would change if I added a where statement to the data statement below. I.e. if I said (where=(enginesize>3)) then it would update the observation number in the graph produced to the actual number of relevant observations (obviously less than 428 in this case).

Thanks

proc sgplot data=sashelp.cars;
  histogram EngineSize / nbins=18;
  density EngineSize;
run;

Re: How to add number of observations to an SGplot?

ballardw — Mon, 21 Jun 2021 19:22:31 GMT

Where do you want it to appear?

Re: How to add number of observations to an SGplot?

tarheel13 — Mon, 21 Jun 2021 19:44:50 GMT

This paper should help you. It gives you 3 ways.

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3644-2019.pdf

Re: How to add number of observations to an SGplot?

Rick_SAS — Mon, 21 Jun 2021 20:02:14 GMT

data cars / view=cars;
set Sashelp.cars;
/* put WHERE clause here, if desired */
WHERE EngineSize > 3;
run;


proc sql noprint; 
select N(EngineSize) into :N trimmed 
from cars; 
quit;

%put &=N;

proc sgplot data=sashelp.cars;
  histogram EngineSize / nbins=18;
  density EngineSize;
  inset "N = &N" / border;
run;