Alan and Brendan (of Inside SAS Global Forum fame) weren't the only folks with a camera in San Antonio. Featured scenes include: out and about in San Antonio, the technical opening session, the demo room, the Inside SAS Global Forum crew, the kickback party, and student ambassador video blogging.
Uncategorized
With the release of SAS 9.2, the SAS documentation that accompanies the software has never been more accessible. See for yourself: check out the product documentation for SAS 9.2. Type in a few keywords in the search pane. I just tried "filename http" -- the top link, describing the FILENAME
Even though it's not a military site these days, apparently the Alamo still sees some action. A colleague and I noticed the helicopters hovering overhead during our lunch break yesterday. Advice to conference attendees: don't leave your pleather conference satchel unattended in a public place, lest the local authorities detonate
Tell an experienced SUGI/SAS Global Forum presenter that you are presenting at SAS Global Forum. One of the first questions he or she will ask you is: "What time is your talk?" Because scheduling matters. Certain time slots have a notoriety of their own. For example, "10:30 Monday" means you
If a SAS data view needs to be added to the SAS Metadata, utilize the Import Tables wizard in the SAS Management Console (SMC). "If you use PROC METALIB to import metadata for a SAS® view, the procedure incorrectly assigns a value of DATA to the MemberType attribute. The value
"I have been doing a lot of performance testing recently with the Teradata access engine vs the ODBC access engine on the same Teradata instance, and from the same server the ODBC access engine on Sybase IQ. Setup: This is all done from a SAS 9.1.3 SP4 installation, with the
I wanted to share a trick/technique with you all regarding making it easier to migrate EG projects from one environment to another. The issue is that there are often occasions where it is necessary to code file paths in an EG project (just like in any other SAS program) and
When trying to generate rollup measures for further statitical analysis from an OLAP cube, completing in MDX proved much more efficient then querying and running PROC MEANS steps. Included is an example of how to utilize the DRILLUPMEMBER() function in MDX code: http://www.databasejournal.com/features/mssql/article.php/10894_3572621_2
![clear.gif](https://blogs.sas.com/content/sastraining/files/2009/10/clear.gif)
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
![clear.gif](https://blogs.sas.com/content/sastraining/files/2009/10/clear.gif)
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;
In SP4, you can export OLAP cubes into .xml files. Right click the Cube from SAS OLAP Cube Studio, select 'Export Cube'. This is an appropriate part of a migration strategy through dev-test-production, since they can then be imported through the 'Import Cube' button on the left menubar.
Three different setups for SAS JMP are listed below. Upwards compatibility (i.e. level 1 to 2) available, downwards less likely (like we know STPs are not). Level 1. SAS JMP and SAS Base installed and licensed on individual desktop/laptop. Level 2. SAS Integration Technologies installed on server, SAS JMP installed
![](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
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
If you think that baby names and data analysis have nothing to do with one another, then you haven’t read Freakonomics. When my wife and I were expecting our third daughter, we had specific criteria in mind for her name. I used SAS Enterprise Guide and data from the Social
Pausing and restarting the Metadata Server manually will allow you to take a full copy of the foundation file structure. However, the %OMABAKUP macro does this for you, which reduces the metadata server's downtime. (Yes, do not run a manual pause or stop of the metadata server when executing %OMABAKUP)
![](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
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
Information Week released its list of 15 Innovators & Influencers Who Will Make A Difference In 2008. From the article: Meet 15 people who will help shape the business technology world in the coming year. They're not the usual suspects -- the names everyone knows. Several are industry and tech
![](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-4.png)
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
Hot off the reel, the SAS for Dummies podcast is now available. Tune in now and hear the juicy tidbits of the story behind the book. Okay, it's no E! True Hollywood Story, but it's as exciting as I get without being on fire. P.S. Shelly Goodin from SAS Press
In a recent Dr. Dobb's Journal piece, Jim Starkey (senior architect for MySQL ) acknowledges that it's time to embed the power of applications within databases, instead of the other way around. Jim says (italics added by me): I think we can agree that context switches or network round trips
Our SAS usage notes usually do a great job of matching symptoms to solutions. But good old SAS note 10751 really stretches the limits of logic. The symptom: a message during the SAS 8.2 setup process that says "string variable is not large enough for string". The solution: "To circumvent
Check this out:http://support.sas.com/techsup/unotes/SN/020/020072.html “IMPORTANT NOTE: You should NEVER use an Unrestricted User (the "unrestricted user" account; for example, the sasadm ID with a "*" prefix in the adminUsers.txt) to log on to any client application except SAS® Management Console. The "unrestricted user" account is intended to be used ONLY as
Included are some resources to help those of you who need to change SAS account passwords on your BI installation. (Notice: This is not for the faint of heart.) http://support.sas.com/rnd/papers/sugi31/securedeployment.pdf http://support.sas.com/documentation/configuration/bisecag.pdf (Chapter 5 & specifically pg98-102) http://support.sas.com/techsup/technote/ts736.pdf Side Note: SAS Technical Support and R&D; have a utility in their 'toolpool'
![](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-3.png)
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.
Today was "career day" in my daughter's 3rd grade classroom. A few privileged parents were invited to attend and answer questions about their professions, press-conference style. Among those on a panel of nine parents, the panelists that saw the most action included the Dog Trainer, the Duke Life Flight Nurse,
Congratulations to the support.sas.com team for a successful update to the SAS customer support center. I hope you'll agree with me that the new look is clean and attractive, and I think you'll find the site is easier to use now. I have the privilege of participating on the committee
During his bettermanagement.com seminar on Monday, Super Crunchers author Ian Ayres suggested that high school students would be better served by acquiring a modest knowledge of statistics rather than learning more abstract math topics, such as calculus. (Then again, if we don't favor calculus how will we ever arrive at
I've recently read Super Crunchers, the book by Ian Ayres that I blogged about a few weeks ago. Even though no propers are paid to SAS (I mean, why should the world's largest privately held software company and a leader in analytics get a mention in a book about the
![](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-4.png)
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
![](https://blogs.sas.com/content/sasdummy/files/2017/01/ProgrammingTips-2.png)
"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.