Hi
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
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
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
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.
Go to this blog, there is examples with code on pretty much any graph you can think of:
@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.
Hi
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
@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
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.