Data visualization with SAS programming

Sgpannel Pctlevel in 9.2?

Accepted Solution Solved
Reply
Super Contributor
Posts: 465
Accepted Solution

Sgpannel Pctlevel in 9.2?

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


Accepted Solutions
Solution
‎03-17-2015 01:57 PM
SAS Super FREQ
Posts: 889

Re: Sgpannel Pctlevel in 9.2?

Yes, use a PERCENT format on the column.

View solution in original post


All Replies
Grand Advisor
Posts: 10,210

Re: Sgpannel Pctlevel in 9.2?

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.

Super Contributor
Posts: 465

Re: Sgpannel Pctlevel in 9.2?

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?

Solution
‎03-17-2015 01:57 PM
SAS Super FREQ
Posts: 889

Re: Sgpannel Pctlevel in 9.2?

Yes, use a PERCENT format on the column.

Super Contributor
Posts: 465

Re: Sgpannel Pctlevel in 9.2?

Worked perfectly for me.

SAS Super FREQ
Posts: 889

Re: Sgpannel Pctlevel in 9.2?

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 407 views
  • 0 likes
  • 3 in conversation