Sgpannel Pctlevel in 9.2?

[DavidPhillips2]

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

[ballardw]

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.

[DavidPhillips2]

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?

[DanH_sas · Accepted solution]

Yes, use a PERCENT format on the column.

[DavidPhillips2]

Worked perfectly for me.

[DanH_sas]

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.