Our SQL expert says: From what I can remember there isn't a max length that PROC SQL sets. However, the forum question didn't say what context that the WHERE clause was being used in. That could make a difference, especially with some of the SAS/ACCESS engines. These engines can actually have varying amounts of space set aside for predicates. -- David Kelley, SAS ... View more

If you used the ODS HTML3 driver, I wouldn't expect for you to see a tag. I would expect you to see a tag. I recommend contacting Technical Support, http://support.sas.com/techsup/intro.html . -- David Kelley, SAS ... View more

PROC REG remains available in SAS 9 to customers who have licensed SAS/STAT software. If you're not finding it, that suggests that your site no longer licenses it, or it was not installed. You should check with whoever installs/manages SAS at your site. -- David Kelley, SAS ... View more

With SAS 9 we upgraded our HTML driver. It sounds like you still need to use the legacy SAS 8 driver. Try saying: ods html3 file=....; /* your job */ ods html3 close; -- David Kelley, SAS Message was edited by: David@SAS at May 3, 2006 12:16 PM ... View more

Sajjad, This question is best answered by our excellent Technical Support staff. Please browse to http://support.sas.com/techsup/intro.html . -- David Kelley, SAS ... View more

Jack, You can customize the record separator in the ODS portion of the SAS registry. The DMS "regedit" command or PROC REGISTRY are ways to do this. -- David Kelley, SAS ... View more

Some of the SUGI 31 ODS slide presentations are now available. They're in PDF format. See the section SUGI 31 Papers of http://support.sas.com/rnd/base/index-papers.html . -- David Kelley, SAS ... View more

Check out http://support.sas.com/rnd/base/topics/odsmarkup/ to learn more about the ODS MARKUP destination. -- David Kelley, SAS ... View more

Michael, I'm not aware of a way to do what you want. -- David Kelley, SAS ... View more

Those macros you mention appear to have been contributed to the online SAS community SAS-L by a user. I am not familiar with them. You can use ODS to generate RTF output from SAS. Word will import RTF. All you have to do is: ods rtf file="myfile.rtf"; /* run your macros */ ods rtf close; -- David Kelley, SAS ... View more

Jack, We haven't uploaded the SUGI PowerPoint presentations to support.sas.com. Send a request for them to ods@sas.com, and we'll get them to you. -- David Kelley, SAS ... View more

Peter, Currently it's not possible to get the pagination behavior you desire from ODS PRINTER. You're not the first customer to ask for it. I could envision adding a PRINTER option to control it in a future release of SAS. -- David Kelley, SAS ... View more

ODS papers, as well as all other SUGI papers, are now available online at http://www2.sas.com/proceedings/sugi31/toc.html . -- David Kelley, SAS ... View more

Please submit your suggestions for improvements or additional forums using the form available at http://support.sas.com/contact/comment-form.html . -- David Kelley, SAS ... View more

Our ODS LAYOUT expert in R&D is away this week (SUGI). We should have an answer for you early next week. -- David Kelley, SAS ... View more