topic Re: Proc Gplot: Axis values in SAS Procedures

Proc Gplot: Axis values

Greek — Mon, 05 Aug 2013 15:13:32 GMT

Hello!

Does anybody know how to change the axes values? I am plotting a series of scatterplots and when the numbers get too big sometimes they appear in scientific notation. How can I change that?

Unwanted Y-axis:

Desired Y-Axis

Re: Proc Gplot: Axis values

AncaTilea — Mon, 05 Aug 2013 15:33:28 GMT

Hi,

Without any sample data/code, I created something...

DATA HAVE;

DO I = 5000000 TO 25000000 BY 5000000;

REVENUE = I;

PROFIT = I/20;

OUTPUT;

END;

DROP I;

RUN;

PROC FORMAT;

VALUE BIG 5000000 = "5,000,000"

10000000 = "10,000,000"

15000000 = "15,000,000"

20000000 = "20,000,000"

25000000 = "25,000,000"

;

QUIT;

GOPTIONS RESET = ALL;

AXIS1 LABEL = (F = ARIAL H = 2 A = 90 "REVENUE" )

ORDER = (5000000 TO 25000000 BY 5000000) V = (F = ARIAL H = 1.5);

PROC GPLOT DATA = HAVE;

PLOT REVENUE * PROFIT/VAXIS = AXIS1;

FORMAT REVENUE BIG.;

RUN;QUIT;

Bascially, I think you may need to use some format.

Good luck!

Anca.

Re: Proc Gplot: Axis values

ballardw — Mon, 05 Aug 2013 17:04:21 GMT

I'm guessing the the likely current format for your predicted variable is BEST8. You don't need a custom format COMMA12. should work for your displayed example.

If you aren't interested in the level of control an AXIS statement gives add statements similar to:

Format minsalary comma12.;

label minsalary = 'Predicted';

to the proc statements.

Re: Proc Gplot: Axis values

Greek — Mon, 05 Aug 2013 22:16:46 GMT

Formatting worked!

Thank you all very much!