All Posts
I’ve never found a great user guide, not to say that one doesn’t exist. You should be able to schedule any type of executable/job like a batch file from using the Platform LSF client tools (packaged with the server tools). You can also use command line executables like bsub and
The data table creation date is sometimes necessary, say in the footnote of your stored process. Included below is a sample to retrieve this date from the file system. /*Open the dataset*/ %let dsid=%sysfunc(open(sashelp.shoes)); data _null_; /*grab the CRDTE function*/ ddate=%sysfunc(attrn(&dsid;,CRDTE )); /*Format in DDMONYY*/ call symput('ddate', put(ddate, dtdate9.)); run;
Are you a SAS programmer who does not yet use SAS Enterprise Guide? If so, what are you missing? That's the topic of my SAS Presents paper at SAS Global Forum: Find Out What You're Missing: Programming with SAS Enterprise Guide. From the introduction: More and more SAS programmers are
It's only January, and SAS Global Forum 2008 isn't until March, but folks around here have already been preparing for months. For my part, I'm on the hook for two papers: one "invited" (submitted and accepted by the SAS Global Forum committee) and one as a "SAS Presents" (topics that
Even if you don't use Microsoft Office 2007, you might have noticed more ".xlsx" files floating around lately. Perhaps you've been sent one or two that you can't open. XLSX is one of the new Microsoft Excel 2007 file formats. (Others include XLSB and XLSM.) Like many software applications, SAS
SAS tip-meister Phil Mason shares a veritable cornucopia of tips at the CMG 2007 conference. Check it out, and learn how a healthy diet of flexible DATE formats can keep your Perl expressions regular.
In his blog, Jared details the hoops one must jump through to convince SAS to run system shell commands (such as the X command and SYSTASK) from SAS Enterprise Guide. Here is the explanation: SAS Enterprise Guide is a client application, and SAS runs as a server application. When launched
"Cut him in half and count the number of rings?" Some folks on the discussion forum share a better method to calculate someone's age from SAS Enterprise Guide.
If you deploy the SAS 9 environment on Windows, you may have multiple SAS processes running on a single box (metadata process, OLAP server, multiple workspace servers). Windows Task Manager doesn't provide a great way to distinguish one sas.exe process from another, but Process Explorer does. Process Explorer lets you
My new favorite typeface for programming is Consolas, a font designed for use with Microsoft Visual Studio 2005. I use it there, but I now also use it for SAS programming. It uses ClearType technology, so the "crisp and clean" benefits kick in only when you have ClearType smoothing enabled.
A colleague asked me to run a certain SAS program and then try to view the output in SAS Enterprise Guide. The output contained an SQL VIEW, and darn it, the application refused to open it, reporting only that the data "could not be opened." There was nothing wrong with
Let's say you use SAS Report format, the latest tagset supported by ODS. After all, it's the lingua franca of SAS BI applications, since it's also used by SAS Web Report Studio, SAS Add-In for Microsoft Office, and SAS Enterprise Guide. You've discovered how to use the report builder in
In the SAS BI-ogsource, Angela posts some sample SAS code for updating library definitions using the METALIB procedure. SAS Enterprise Guide users can make use of a friendlier interface to do the same job. Now available for download, the Update Library Metadata task plugs right into SAS Enterprise Guide and
So you have installed the SAS System, and you can check what is licensed with the proc setinit command, but what if something hiccuped in the install. Or your supporting (I mean validating) someone else's install and you need to quickly see what is available? Included below is some 'found'
