I guess it's better to show you my code (and no, I'm not proud, I'm just learning SAS) to show you where I am at. You can see that I summarize the data USER.RMFINTRV by SYSTEM and HOUR variables. I then want to loop through each unique SYSTEM and plot a chart and draw a table. I don't want to repeat the PROC SGPLOT and PROC TABULATE with each hardcoded unique value in the SYSTEM variable. ... View more

Sorry data_null_; After I read what I wrote, I needed to clarify. Say I want to do multiple plots of the same unique variable. PROC PLOT DATA=A.CARS; WHERE COLOR='BLUE'; TITLE 'BLUE CARS'; VBAR YEAR / RESPONSE=PRICE; RUN; PROC TABULATE DATA=A.CARS; WHERE COLOR='BLUE'; CLASS YEAR; VAR PRICE; TABLE PRICE / HOUR; RUN; Or did you mean applying the BY statement on the DATA step? ... View more

Sure, and I'm not even sure I'm going about this correctly or explaining it correctly, but here is what I'm trying to avoid: DATA A.CARS;    SET B.CARS; KEEP MANUFACTURER MODEL YEAR COLOR DOORS ENGINE PRICE; PROC PLOT DATA=A.CARS; WHERE COLOR='BLUE'; TITLE 'BLUE CARS'; VBAR YEAR / RESPONSE=PRICE; RUN; PROC PLOT DATA=A.CARS; WHERE COLOR='RED'; TITLE 'RED CARS'; VBAR YEAR / RESPONSE=PRICE; RUN; PROC PLOT DATA=A.CARS; WHERE COLOR='BLACK'; TITLE 'BLACK CARS'; VBAR YEAR / RESPONSE=PRICE; RUN; I want to be able to loop through every unique COLOR of car, without knowing all the colors in the data, and be able to perform one PROC PLOT statement. I'm trying to not have to hardcode variable values in the plots (in this simple example). ... View more

Reeza, The file is created, with the .xlsx extension. I e-mail it to myself and the attachment opens under Excel. But the data is garbage, most likey due to a lack of conversion from EBCDIC to ASCII I'm assuming. Code examples I've found online claim you can produce Excel workbooks, complete with charts, all through HTML and open the file in Excel. So far I haven't been able to open a workbook with charts. ... View more

Cynthia, This was a seperate question based off all the information you and other gave me in my previous post. I am able to chart simple data into the body of e-mails and send them via mainframe SMTP. Based off of your suggestion, I did open a track with SAS support, asking them if it is currently possible to embed HTML to the body of an e-mail (even under SAS v9.3). They informed me that it is currently not possible, nor is it a function they are pursuing in the near future. So that left me with other avenues to pursue if I wanted more than the simple charts I am currently producing. Automation is the underlying key to all of my questions, by the way. So, off of others suggestions, I pursued creating HTML and XML files that were able to be opened by Microsoft Excel. I have never been able to accomplish this. I've found bits and pieces of code online and put together a "working" program that is creating an HTML file with a .XLSX extension (at multiple suggestions). And when I say working, I mean it produces an HTML file in the zfs directory I point it to. But to date I have not been able to successfully open the file. My direction with all this was to chart all the data, save to an HTML file that Excel could open, then send that as an attachment in an e-mail. This is what spawned my question for this post. While playing around with the HTML, I  have been able to manage to create simple web pages with the charts imbedded and serve them directly off the zfs directories. With these I can send the links embedded in the body of an e-mail and just have the end users branch to the pages. Again, my underlying effort here is automation. I think this is possibly my best avenue at this point. Now my efforts are focused on sprucing up the charts. I want to be able to create stacked bar charts with "tables" containing the metrics underneath the charts. I am still using PROC CHART, PROC PLOT and PROC GBARLINE but am trying to read up on ODS statements. I'm still a newbie to all this but am not giving up. ... View more

Cynthia, I am initially working with the CHART procedure just to make sure I get the chart looking the way I want it. I figure that I would convert to the GCHART procedure and wrap the ODS statement around it. I actually tried the ODS HTML around the CHART procedure and e-mailed it, but it came out garbage. So now my question is basically can I send a bar chart created by the SAS procedure CHART/GCHART in an ODS format that will retain the chart? I would almost HAVE to believe someone is doing this already. Jeff ... View more

Ok, I have the basic CHART procedure working: PROC CHART DATA=USER.xxxxxx; VBAR AVGCPU / DISCRETE TYPE=PERCENT;      BY HOUR; WHERE SYSTEM='xxxx'; This produces a basic chart with the correct axis. Now I would like to incorporate the chart into the body of an e-mail. I have the e-mail functionality working. I would like to stay away from creating a PDF and attaching it to the e-mail though. Jeff ... View more

Cynthia/ballardw - yes I should have included an example of what I'm trying to do. I've changed my code so much to try different things. Here is essentially what I'm trying to accomplish. I have z/OS performance data from MXG in the following order: (CECSER SYSTEM DATE HOUR PARTNCPU AVGCPU MAXCPU TOTCPU NRCPUS AVGZIP MAXZIP TOTZIP NRZIPCPU AVGPLAT TOTPLAT) All I want to do (to start with) is create a simple bar chart, charting avgcpu by hour. Simple. I've attached a simple PDF I created from Excel to show what I'm trying to accomplish. I am unclear on how to set the CHART procedure to accomplish this. And yes, I can use the PDF format for ODS. Never used ODS at this point either. You can tell I'm brand new at SAS..... Essentially I want to create a stacked chart with two of the variables above (avgcpu/avgzip) by hour for each system, output to PDF, then e-mail groups all from the mainframe SMTP. Cynthia - thank you for the links. I will review them. Regards, Jeff ... View more

Sure, the field is 6 bytes long and here is an excerpt: 477273 477273 475727 475727 475727 475727 475727 1001k 1001k 1001k 998450 998450 998450 998450 998450 998450 998450 998450 998450 I really don't care what output looks like, as long as it is in "a" correct format. I need to summarize this data and the input format needs to be big enough to hold petabyte/terabyte size fields? I'm not sure I am stating that correctly. ... View more