Although many of you may not own up to it, I bet you watched at least one episode of Dallas in the early ‘80s. I haven’t yet seen the reboot of the series, but plan to. Dallas’ “Who Shot JR?” plotline, as well as the contrived writing-off of an entire
Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE
A common question really and one that I get after posting code like yesterday's All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has anyone got any tips on when those
Have you ever seen question marks in ODS output, diamonds with question marks in them where a copyright symbol should be, or unexpected symbols in your Web browser? In other words, do you sometimes see garbage instead of text? Manfred Kiefer’s new book, SAS Encoding: Understanding the Details can help.
Stored process code can exist within the metadata itself for version 9.3 (the benefits of which I discussed earlier). But for all other versions (and as a option in version 9.3) the SAS code is stored as a .sas file within the server's file system (or mapped folder/drive structure). When editing
As SAS users, you rely on books from SAS to stay informed about the latest software updates and industry best practices from SAS authors. As the organization that brings you those books, Publications Division employees attend trade shows, conferences and workshops for professional development and meet with publishing partners to
The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option
This week's %NLINMIX macro tips come from the esteemed authors of SAS for Mixed Models, Second Edition. Ramon C. Littell, George A. Milliken, Walter W. Stroup, Russell D. Wolfinger, and Oliver Schabenberger combined their expertise to write this indispensable guide. This 800 page book has made a big impact in the user community
Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your saved connection profile for SAS applications lock
