Hi, in Base sas there is the possibility to assign keyboard keys to some operations ,such Refresh ,by initially typing F9 . Then, type refresh next to the key you may want to assign the refresh operation and so ,every time you want to refresh your work space , you just need to use the shortcut that you have choosen.    Regards ... View more

Well you could use SAS 9.1 on your server to pre-summarise your data and then just download the summary needed for graphing. Of course you would have to know the type of summary in advance but that shouldn't be too difficult to figure out.  ... View more

The SPDS engine just hides the fact that it does a sort on its own when a different sorting order is requested. At least with 9.2, that sort used the same UTILLOC and logic that proc sort uses, and has the same performance; only the initial read of the dataset is speeded up by the engine.   I much more like it when I see what is really going on represented in the code. But that's the programmer in me, that speaks from decades of experience and is wary of the fads of "modern" languages. ... View more

I've pretty much said farewell to Excel for quite sometime but unfortunately, the current employer uses Excel pretty extensively. I'm pretty much bounded by the analytical culture here. ... View more

Post the actual log with the code. Your  example has a couple of different opportunities for a file not to exist.   Also are you running in a server environment? If so you may have mulitple other issues such as the paths not being recognized bythe server (causing file not to exist) and that Excel is not available.   The DDE Excel SAVEAS command wants a file format indicator (you may be using 1 for that in your syntax) that is variable depending ont the file type created such as XLSX or XLS (different formats) and depends on the version of EXCEL doing the saving. For example 56 is to save as an XLS file from Excel 2007-2010. At least in the last working DDE example I have. ... View more

@Quentin Sorry, I was commenting on the expectation of SUGI's existing on GitHub when they predate it significantly. I'm not sure someone can appreciate the body of knowledge that's managed to stay open in SAS although it is not open source.    I'm not sure GitHub is organized for something quite like SAS Global Forum but I may not understand it well enough in terms of managing multi-user projects.    I think what the original poster is interested in, is something that sascommunity.org may have been aiming to accomplish originally.  It's a valuable resource anyways.  ... View more

@afiqcjohari Since we are providing various alternatives another very flexible way to summarize and tranform in the same step is with PROC REPORT.  Although i believe used less often to create a data set, it also has an OUT= option.  In each of the three methods that have been presented to you the MLF option is an alternative way to summarize across CLASS levels. proc report data=txn out=wide; column txntype date,txnamount; define txntype / group f=$txncode. mlf preloadfmt order=data; define date / across f=monyy. order=internal; define txnamount / sum; run;   ... View more