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;
Special Character problems in passwords continue to cause issues, and many organizations require the use of at least 1 to pass security requirements. Specific ones to stay away from ... @ ... Just today this caused problems in remote connections to Meta Engine Libname. & ... This can affect users
If your SMC or other metadata-based SAS tools seem to take a long time to load up when connecting to the metadata server you may benefit from running a reorg. The %OMABAKUP macro includes a reorg parameter which reduces the amount of fragmentation in how the datasets making up SAS
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'
For BI Installations, a SAS Service Configuration Utility is available to manage your sas services in a window's environment. Go to Start->Programs->SAS->SAS 9.1 Utilities->SAS Service Configuration Utility. You can install, remove, and set options on the Windows Services. (Thanks goes to Bryan for pointing neat utility out.)
Today, I needed to figure out how to create a simple measure for OLAP and have it available to the users. Fortunately, EG has a great Create New Measure GUI for this! It creates the MDX code on the fly! Okay, bear with me. There are several steps to this,
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
Enterprise Guide has a wonderful OLAP Viewer if you don't/can't use the web stuff. I went to the SAS Course 'Creating and Exploiting OLAP Using the SAS System' which has in the Course Notes some great steps on using EG for OLAP Viewing. Basically, the 'Tasks by Category' menu has
