topic Calling specific bar graphs from PROC FREQ in SAS Programming

Calling specific bar graphs from PROC FREQ

Nikster101 — Thu, 21 Oct 2021 07:04:43 GMT

Hi there. I have the following proc freq procedure:

proc freq data=project;
tables gradind;
format gradind newh.;
tables quintile;
format quintile new.;
tables nsfasyn;
format nsfasyn $newn.;
tables nsfasyn*quintile*gradind/ plots=freqplot (twoway=cluster scale=percent) out=graphs5;
run;

The graphs below are from the proc freq procedure:

How do I call the graph NSFASYN= NO FUNDING only into the proc sgplot prcedure? (or even the NSFASYN= FUNDING only). I have tried using the (where=(nsfasyn='No Funding')) in the sgplot statement but it did not work. Any ideas

proc sgplot data=graphs5 (where=(nsfasyn='No Funding'));
vbar quintile/ group=gradind groupdisplay=cluster response=percent datalabel;
run;

Re: Calling specific bar graphs from PROC FREQ

ChrisNZ — Thu, 21 Oct 2021 22:49:16 GMT

I have tried using the (where=(nsfasyn='No Funding')) in the sgplot statement but it did not work

There's no reason it shouldn't work. Is that the correct value (including case)? What does the log report read?

Re: Calling specific bar graphs from PROC FREQ

Nikster101 — Fri, 22 Oct 2021 22:34:14 GMT

It did not generate a log, I am unsure of what happened. When I took out the where statement it generated the log and output graph