topic Re: boxplot in Graphics Programming

boxplot

mukeshmehata1 — Tue, 01 Aug 2017 15:32:02 GMT

I have facing problem to produce box plot for wide range dataset. Please give me some hints. So, that I can produce box plot. I have attached my data. Thanks

Re: boxplot

ballardw — Tue, 01 Aug 2017 15:40:01 GMT

Have you brought your data into SAS?

After you have data in SAS, Proc Sgplot would be one way to start. One example is here : http://support.sas.com/kb/43/090.html

Re: boxplot

RW9 — Tue, 01 Aug 2017 15:49:16 GMT

Go to this blog, there is examples with code on pretty much any graph you can think of:

http://blogs.sas.com/content/graphicallyspeaking/

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 16:31:09 GMT

Actually, I want to produce box plot with the different months (png file is attached which I produced using by r). If you have any ideas to produce such kind of plots, I will be grateful. Thanks

Re: boxplot

Jay54 — Tue, 01 Aug 2017 16:47:22 GMT

See article: http://blogs.sas.com/content/graphicallyspeaking/2016/12/08/getting-started-sgplot-part-3-vbox/

You will need to convert your multi-column data into grouped data, with two columns, Month and Temperature.

Re: boxplot

Reeza — Tue, 01 Aug 2017 17:25:14 GMT

@mukeshmehata1 Please post what you've tried so far and we'll be happy to help you. This looks like homework, so you're unlikely to find someone to provide the exact answer.

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 18:21:45 GMT

I have transposed the data. I got Jan to Dec under _NAME_ and produced COL1 to COl 66 as temperature obs. If I can arrange those data then I can produce box plot with the different month. I Don't know how to arrange these columns. So that I will have 66 temp points in each month. Attached file is here.

Thanks

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 18:32:46 GMT

I Just want two columns only..one is Month and another is temp value. So, I will have total rows = 12*66

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 18:42:57 GMT

Yeah It's a homework. But I don't expect to get all the solution. I just need hints. Then, I can do remaining portion.

Re: boxplot

Reeza — Tue, 01 Aug 2017 19:06:04 GMT

@mukeshmehata1 wrote:
Yeah It's a homework. But I don't expect to get all the solution. I just need hints. Then, I can do remaining portion.

This is now different from your original question, so it's getting hard to follow. What do you need answered how?

Please post what you ahve and what you want as examples. For reformatting data from wide to long, look into PROC TRANSPOSE

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 19:14:32 GMT

Yeah I want helping to generate simple code so that I will have 2 columns. One column is with Jan to Dec and another col is temp value

Re: boxplot

Reeza — Tue, 01 Aug 2017 19:16:27 GMT

https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

Follow the examples above.

EDIT: the first example is manual the second array method is probably what you'll find the easiest to understand.

Re: boxplot

mukeshmehata1 — Tue, 01 Aug 2017 19:32:21 GMT

Thank you! It worked.