topic Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis in SAS Procedures

Step Plot /Chart/ Graph with Nominal attributes on Y axis

Tebunah — Wed, 03 Aug 2016 19:40:28 GMT

Dear Community,

While trying to compute some step chart, I came across to the code listed below found in the SAS help documentation.

title "Stock Trend for IBM";
proc sgplot data=sashelp.stocks
  (where=(date >= "01jan2004"d and stock = "IBM"));
  step x=date y=close;
run;

The hand's drawing is the plot I would like to compute: the challenge appears to the visual aspect as the attribute on the y-axis will be ranked by order/ severity ascendant.

Please advise.

Thanks in advance.

Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis

ballardw — Wed, 03 Aug 2016 20:14:09 GMT

You may be looking for the annotate feature to draw lines at points decided by values in the data. BUT you will have to provide the code on how to select a point and then draw the horizontal and vertical unless you want the lines at each corner.

If you only want your values of interest then you would suppress the default axis statements and supply your values which might be easiest with the annotate.

Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis

Tebunah — Wed, 03 Aug 2016 21:38:50 GMT

Thanks ballardw, actually the lines are not required @ each corner. the dashes were to reference them from the other axis. However I wou

Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis

Tebunah — Wed, 03 Aug 2016 21:40:28 GMT

Sorry 😞 I would be interested in the annotation.
Did you mean renaming them ?
Thanks

Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis

ballardw — Wed, 03 Aug 2016 22:01:30 GMT

It may be time to clarify the question. Do you have a dataset you want to plot? If so, what does the data look like. You can follow instructions from this link: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 to make datastep code that can be pasted here for the variables of interest.

Or are you trying to get values from an existing graph?

Re: Step Plot /Chart/ Graph with Nominal attributes on Y axis

Tebunah — Wed, 03 Aug 2016 22:20:58 GMT

Thanks ballardw, actually was trying to convert the numerical values from y-axis to categorical for visualization purpose. I used the 'proc format' to solve it. Many Thaanks