topic Re: Custom Graph in Graphics Programming

Custom Graph

GPatel — Wed, 25 May 2016 21:32:51 GMT

How can I create a custom graph shown in an attached Excel file ?

Sample data and custom graph is shown in an attached file.

Re: Custom Graph

Reeza — Wed, 25 May 2016 21:56:56 GMT

3D plots are not really useful in terms of data visualization, I would recommend using a flat bar chart instead. In a 3D chart, it's hard to line up the top of the bar to the axis to determine what the values are.

You'll need to code for this type of graph, since I don't think you can do it through the point and click interface.

I would recommend GTL, though SGPLOT has some good options.

What version of SAS are you on? Graphing options are changing very quickly in the last few years/releases.

You can find sample graphs here, with data and code:

http://robslink.com/SAS/Home.htm

https://support.sas.com/sassamples/graphgallery/

I'll move your post to the graphics forum so some of the graph guru's can help.

Re: Custom Graph

GPatel — Wed, 25 May 2016 22:45:54 GMT

I m using SAS 6.1 EG.

Re: Custom Graph

Jay54 — Thu, 26 May 2016 00:41:56 GMT

It will be easier if you change your data where "Flags_A", "Flags_B", etc are in a category column, the "Yes" and "No" are group values for each category and the value is in a "Value" column. Then, you can use SGPLOT with one VBAR statement with a GROUP option. We need to know the SAS version you are using, in addition to the EG version.

proc sgplot data=data;

vbar category / response=value group=group dataskin=pressed;

run;

Dataskin=pressed will give you a cylindrical look, You can customize further with other options. See product documentation.

Re: Custom Graph

ChrisHemedinger — Thu, 26 May 2016 13:09:38 GMT

From your example, it looks like you shared a SAS Report that you build in EG (SRX output) -- using either the List Data wizard or Summary Tables task, so I imagine your source data is "flatter" than what you're showing with the across columns. If you shared your raw data, it would be easier to share exact code that could reproduct the chart you want.

Re: Custom Graph - Resh

GPatel — Thu, 26 May 2016 22:05:23 GMT

The output I shared yesterday was resulting data from proc tabulate procedure.

Below is Raw_Data and I want to reshape the data as shown below.

Then I can used proc gchart.....

	RAW_DATA
Obs	Flag_A	Flag_B	Flag_C	Flag_D	Flag_E	Flag_F	Flag_G	N
1	No							1
2	Yes							2
3		No						3
4			No					4
5			Yes					5
6				No				6
7				Yes				7
8					No			8
9					Yes			9
10						No		10
11						Yes		11
12							No	12
13							Yes	13

	Reshape_Data
	Flag_A	No	1
	Flag_A	Yes	2
	Flag_B	No	3
	Flag_B	Yes	0
	Flag_c	No	4
	Flag_c	Yes	5
	Flag_d	No	6
	Flag_D	Yes	7
	Flag_E	No	8
	Flag_E	Yes	9
	Flag_F	No	10
	Flag_F	Yes	11
	Flag_G	No	12
	Flag_G	Yes	13

Re: Custom Graph - Resh

Jay54 — Thu, 26 May 2016 23:22:28 GMT

I cleaned out your xls file, keeping only the reshaped data and one sheet and added column headers.

Here is GCHART and SGPLOT code.

proc import datafile='C:\Reshape_Data.xlsx'
dbms=XLSX out=ExcelData replace;
run;

proc gchart data=ExcelData;
vbar group / sumvar=value group=cat;
run;
quit;

proc sgplot data=ExcelData;
vbar cat / response=value group=group groupdisplay=cluster dataskin=pressed;
yaxis integer;
run;