comp.soft-sys.sas - The SAS statistics package.
Working in SAS 9.1, Windows XP. I get the error referenced in the subject line when attempting to utilize Proc Print after I have previously created a report using ExcelXP tagset and ODS. I have to exit and re-enter SAS to solve the problem. Wassup, and is there a better way to fix this?
Recently I was asked to produce a Powerpoint presentation directly from SAS with frequency tables and graphics on hundreds of different slides (DON'T ask me why! Mine is not to wonder why....) While there are several papers on outputting to Powerpoint, it generally involves using linked excel files and hand-linking the desired files which will then update automatically. For a small PPT presentation this is reasonable but not on the scale desired by the requestor in this case. It's rumored that a powerpoint destination will be possible in 9.2 and might be possible now with the Microsoft add-in which I don't have, but it seems like maybe someone else has figured out a way. I did discover that one can generate a RTF file with slide headers and import that into powerpoint pretty seamlessly, but I'd like to automate putting the data in too. The process seems to generate a slide for each line, going to a new slide at the line's end. If there was a clever way to strip the line end and put it in after a table or graphic maybe that would do it... Or maybe putting in a link that would expand out once in the slide with an embedded line break to demarcate it from the slide title somehow.... Any thoughts or advice? A fun little exercise in the dog days of summer - the presentation, done the hard way, has been finished for some time but my curiousity lingers on! Thanks in advance!
Can SAS be written so a user clicks a button and the SAS code behide the button brings up like a text box so criteria from and user can be place in the text box to generate the right report that the user needs? if so can someone give me some sample code to see how this is done?
Can anyone tell me how I can get the names of all of the active librefs into a dataset? I know I can get the active librefs through libname _all_ list but that just writes to the log (and I don't seem to be able to even get that output to an external file that I could read in). TIA!