Hi Matt S is available in Unix SAS but not PC SAS. For PC SAS I typically use Q. This is so that my index finger could reach A, C, Q while my thumb hold down the CTRL key. But you could use any other available keys.  Duong ... View more

My response was under the assumption that Matt wants to submit SAS codes interactively but preferred to use a non-SAS editor. If you don't have Eguide and you are using Unix SAS the DMS editor is not great so you might want to use this gsubmit technique.  In response to Linus - I am not sure if you had read the paper carefully. Instead of the SAS DMS editor panel you use UEdit in its place. The SAS environment will still be the exactly same. That is the log/output will still go to DMS log/output. You will not lose any SAS functionality but have an option to choose an alternative editor. And if you are still on SAS DMS you might want to try this with gsubmit. http://www.lexjansen.com/phuse/2011/pp/PP02.pdf Duong ... View more

Hi Matt You can do something like this. http://www.lexjansen.com/phuse/2011/pp/PP03.pdf I prefer using Ultra Edit or Notepad++ too. Duong ... View more

Hi Natalie This is a topic I see people asked again and again because SAS Institute have not document this properly. A few years ago I spent quite a bit of time experimenting this and have documented my findings in this paper  http://www.lexjansen.com/phuse/2007/po/po06.pdf  I believe it is complete. With this topic I think you'll need to understand its fundamentals otherwise you will keep coming up with questions - why works here and not there etc. If you go through the paper above thoroughly hopefully you won't have these issue again. Regards Duong ... View more

Hi all This question becoming more common for those who work in the Pharmaceutical Industry. There are a number of papers on this topic: http://www2.sas.com/proceedings/sugi31/066-31.pdf http://www.pharmasug.org/download/papers/CC18.pdf http://www.pharmasug.org/cd/papers/TT/TT13.pdf I disagree Cynthia statement's above - "almost impossible to read the RTF file directly with SAS". In fact extracting an RTF table into SAS is quite simple. I have written a paper about this. http://www.lexjansen.com/phuse/2008/po/po03.pdf That is by using an RTF regular expression you can easily strip out the RTF control words. Also Cynthia, in clinical trial reporting it is very typical that one programmer do the table and another QC it. And because the table could be re-ran many times, programmers preferred a programmatic way of doing the QC (refer to Hagondoorn paper above) Tom suggestion to save the RTF as text then read into SAS is really not appropriate for this purpose. Because separating the columns into variables would be a challenge!! What you want is column1 go to var1 and column2 to var2 etc. So if the file is in text it is not easy to identify where the columns separation are. Another alternative is to copy and paste into Excel then use DDE. This could be done automatically (ie on the fly) I believe. I have not looked in depth into this. The reason is you need PC SAS for this method and many bigger pharmaceutical companies uses UNIX SAS.   As for the clipboard I have not tried this but it seem the same as copy and save as text method. If it is then you would have the same issue. Regards Duong ... View more