topic Re: Formatting a PROC FREQ table in ODS and Base Reporting

Formatting a PROC FREQ table

greg6363 — Tue, 12 Feb 2019 17:04:35 GMT

Is there any way to format the y-axis of a graph creating in PROC FREQ OR PROC SGPLOT? Since I have a large numeric range for the value on my y-axis, I want to add a comma to the numeric format. Instead of presenting the intervals as 10000, 20000, 30000, etc, I want to show them as 10,000, 20,000, 30,000, etc.

Any assistance would be greatly appreciated. Thanks.

Re: Formatting a PROC FREQ table

Reeza — Tue, 12 Feb 2019 17:22:07 GMT

SGPLOT will take the format of the variable and will be much easier to customize compared to the PROC FREQ output.

Re: Formatting a PROC FREQ table

ballardw — Tue, 12 Feb 2019 17:59:32 GMT

Example with a data set you should have available:

proc sgplot data=sashelp.cars;
   scatter x=weight y=msrp;
   format msrp comma6.;
   yaxis values=(10000 to 100000 by 10000, 150000, 200000);
run;

A YAXIS statement with Values=() option can specify specific values you want to appear on the axis. Do not list the values with commas though as the comma is used to delimit values in the list.

Re: Formatting a PROC FREQ table

greg6363 — Tue, 12 Feb 2019 19:19:20 GMT

The problem is that i’m trying to format the frequency which isn’t a variable in the dataset which means I can’t declare it in a format statement.

Re: Formatting a PROC FREQ table

ballardw — Tue, 12 Feb 2019 20:27:16 GMT

So, where is this frequency occurring then?

Provide at least some code of what you are currently doing as we a flying pretty blind.

In general if you want to make plots best is to create an output data set from whatever procedure and plot that. Then there would be a variable representing a value.

Or if you are attempting to manipulate a DATALABEL value then we need more details as some plots will allow setting a format for some data labels.