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;
Where do you want it to appear?
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;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.