A couple of questions: 1) Are there any notes in the log about that format? 2) How do your values appear on the X axis? Thanks! Dan ... View more

This question should probably be posted to this discussion forum instead: http://support.sas.com/forums/forum.jspa?forumID=31 SAS Macro Facility, Data Step and SAS Language Elements They can probably help. ... View more

Hi:   As I explained above, you may need to change the content-type header using the STPSRV_HEADER function in your stored process. You may need to have your Stored Process create package output. You may need to switch the server you use. Sometimes, you might need to use special reserved locations and/or stored process facilities like _SESSIONID or _TMPCAT or _REPLAY. The bottom line is that if your _ODSDEST is MSOFFICE2K or HTML, then you can send tables and graphs to Excel. However, if your value for _ODSDEST is TAGSETS.EXCELXP, then graphs are not supported in that version of Office Spreadsheet Markup Language XML -- by Microsoft design. So this is a question for Tech Support because what you want to do and how you do it will depend on many different factors. cynthia ... View more

Typically, I use Process Monitor to determine if a data set is opened using SGIO. Look for the Create IRP in the Process Mon Log when the file is opened. If the NO_BUFFERING flag is present, then SGIO is being used. In v9.3, there will be messages printed to the SAS Log to indicate that a SAS I/O file is using SGIO or if SGIO was disabled. ... View more

Hi: This is probably a good question for Tech Support. They can look at all your code and get information about your operating environment and provide you with the best advice. cynthia ... View more

SAS 9.1 or 9.2? ... View more

and have a look at the optional values for the system option SASTRACE The examples in the on-line doc should help you choose the level of deatil you need ... View more

Hi Alain, At this point, it would best to contact Techinical support for the resolution of your problem. Regards, -Prashant. ... View more

SAS/Access using ODBC - check the SAS Support site for a conference paper on the topic. Scott Barry SBBWorks,Inc. Suggested Google advanced search argument, this topic / post: outlook inbox site:sas.com ... View more

that is what I did. It worked, and quickly! 🙂 It is easy for me, I only have to pay for a SAS licence. Much more difficult for others who have someone-else paying and providing the hardware and desktop environment 😉 where they want proof-of-value and measured migration timetables and guarantees of compatability and integration and all that stuff .. I imagine 4.3 is good worth the struggle to overcome "management" problems peterC ... View more

That example was NOT done with TAGSETS.HTMLPANEL. It was done with GREPLAY and ANNOTATE, as described here: http://robslink.com/SAS/democd22/tele_info.htm and the program is here: http://robslink.com/SAS/democd22/tele.sas The "objects" in HTMLPANEL are either graphs or tabular objects. Whether or not you can right-align them depends on what part of the object you are talking about. However, since the code for that example is available is there some issue with just using the code example at the above web site?? cynthia ... View more

Here's an example where I use gchart, and produce "overlapping" bars... http://robslink.com/SAS/democd29/robslink.htm http://robslink.com/SAS/democd29/robslink_info.htm Note that I let gchart draw the first bar (back-most bar), and then I annotate the overlapping bars. You can control the charttip/drilldowns of the gchart bars using gchart vbar's html= option, and the charttip/drilldowns of the overlapping annotated bars using the 'html' variable in the annotate data set. ... View more

Ahh - so, really, just a grid of colored boxes, where you control the color. I don't have any examples 'exactly' like yours, but here are some similar, that could probably be adapted ... http://robslink.com/SAS/democd22/heatmap.htm http://robslink.com/SAS/democd22/heatmap_info.htm The technique used in this custom calendar chart could be adapted: http://robslink.com/SAS/democd22/trend.htm http://robslink.com/SAS/democd22/trend_info.htm http://robslink.com/SAS/democd21/emission.htm http://robslink.com/SAS/democd21/emission_info.htm A gplot, similar to the sgplot that was posted: http://robslink.com/SAS/democd10/pltwafer.htm http://robslink.com/SAS/democd10/pltwafer_info.htm And, most of these 'wafer maps' could be adapted to a rectangular 'heat map': http://robslink.com/SAS/democd10/aaaindex.htm ... View more

Oh. I see u are using scatter. That worked. Thanks ... View more