topic Re: Sgpannel Pctlevel in 9.2? in Graphics Programming

Sgpannel Pctlevel in 9.2?

DavidPhillips2 — Tue, 17 Mar 2015 17:46:30 GMT

Does this option for sgpannel exist in 9.2 or a similar alternative?

proc sgpanel data=sashelp.cars pctlevel=graph;

panelby origin;

where origin in("Asia" "Europe");

vbar type / response=horsepower stat=percent

group=cylinders;

run;

I'm following

SAS(R) 9.4 ODS Graphics: Procedures Guide, Fourth Edition

Re: Sgpannel Pctlevel in 9.2?

ballardw — Tue, 17 Mar 2015 17:50:54 GMT

I don't think so. Likely you will need to summarize your data before plotting it.

About 90% of my graphs I presummarize the data because I the direct calculations in the plot procedures won't work. But then much of my data is complex sample data.

Re: Sgpannel Pctlevel in 9.2?

DavidPhillips2 — Tue, 17 Mar 2015 17:54:30 GMT

I created a percentage of the whole column then I summed up the column. My display looks like .0083 and my axis goes from 0 to 1. Can I format the axis and display?

Re: Sgpannel Pctlevel in 9.2?

DanH_sas — Tue, 17 Mar 2015 17:54:42 GMT

Unfortunately, no. However, it is possible to compute those numbers outside of the procedure using a combination of PROC SUMMARY and DATA STEP. Then, you can pass those numbers in to be graphed.

Re: Sgpannel Pctlevel in 9.2?

DanH_sas — Tue, 17 Mar 2015 17:57:11 GMT

Yes, use a PERCENT format on the column.

Re: Sgpannel Pctlevel in 9.2?

DavidPhillips2 — Tue, 17 Mar 2015 18:12:32 GMT

Worked perfectly for me.