Here is a code snippet I came up with today to save output with various _odsoptions AND allow the users to choose what type of output they need: RTF, PDF, or HTML. (Note that this will default to PDF if the user doesn't pick anything. Also there is a report
Running SAS Tasks on one column of data in Excel currently generates an error message. Highlight the column - by using CTRL-SHIFT-END - and then run the SAS Task..
Earlier in the year, I attempted to convert to a SAS Stored Process a SAS IntrNet program that used statements such as: data _null_; set datatable; put 'html code here' variable item; run; However, it doesn't work when simply removing the SAS IntrNet headers (such as options, and ods html
Well, I had a few users this week who wanted to access a print out of one record in the database. Fortunetly, they all know the primary key - so the query was really simple. However, to make it extremely easy for users, I didn't want to link to another
Running a stored process (or STP) is a SWEET thing! All of my users are using the limited number I have made available, and I'm sure many new STPs will be written as soon as the users realize how easily they can be created. When first writing an STP for
A few of the SAS AMO users in my facility (including me) have run into problems around SAS's interation with the normal.dot file. SAS Add-in to Microsoft Office uses the normal.dot as a performance improvement mechanism. SAS stores toolbar and menu information into normal.dot to keep from loading every time
Last week was incredible! The amount of activity from training, supporting and related system administration kept me very busy. The next few posts are my backlog of findings & tidbits. My boss was running into a problem with using a SAS Task from the SAS Add-in to Microsoft Office Excel
