05-25-2016 05:56 PM
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:
I'll move your post to the graphics forum so some of the graph guru's can help.
05-25-2016 08:37 PM - edited 05-25-2016 08:41 PM
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;
Dataskin=pressed will give you a cylindrical look, You can customize further with other options. See product documentation.
05-26-2016 09:09 AM
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.
05-26-2016 06:05 PM
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.....
05-26-2016 07:22 PM
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;
proc gchart data=ExcelData;
vbar group / sumvar=value group=cat;
proc sgplot data=ExcelData;
vbar cat / response=value group=group groupdisplay=cluster dataskin=pressed;