02-27-2015 12:10 PM
Hi I have a query in relation to creating graphs and exporting them to sheets in excel.
I'm trying to automate a process where I export four graphs for a particular factor for 20 factors. Creating macros in excel to do this is very slow and time-consuming. Below is a sample dataset showing details for one factor.
I've included a screenshot of what I want the graphs to look like. So the exposure will be a bar chart, the ratios will be a line chart etc. Is it possible to output in a tiled format? I'm new to sas/graph so any help would be greatly appreciated.
|factor1||2||1000||2000||82%||25%||3000|| 0|| 1||74||463||605||644|
|factor1||3||20000||3000||80%||22%||2000|| 0|| 0||177||477||469||633|
|factor1||4||23000||500||76%||21%||1000|| 0|| 0||185||988||641||494|
02-27-2015 02:51 PM
9.3 with sas/stat, sas/graph, sas/access, sas/export.
Thanks for the link.
In terms of exporting to a program out of sas, can you export to xlsx without it messing up the format? Is it better to output to pdf for graphs. I don't need to edit the graphs as this will all be done in SAS before the export.
Finally is it possible to export 4 graphs on one page/sheet?