All Posts
It’s the last day before the biggest SAS users gathering of the year. I’ve already gotten my registration packet (registration opened about 3 hours ago) and even mapped out a couple of great spots to eat. Now, that I have time to settle in, I thought I’d send you a
Co-hosts Dave Thomas and Waynette Tubbs kick off the behind-the-scenes look at SAS Global Forum 2010. Learn all about the conference's social media plans and how to submit your suggestions story ideas. Web Links:YouTube:https://www.youtube.com/watch?v=7t_UJexoD20 SAS.com:http://www.sas.com/apps/webnet/SGF2010VideoBlog/index.html?videoID=isgf10episode1
...if man is still alive, will he be importing Excel spreadsheets and wondering why his leap years are off? I received this report from SAS Technical Support, on behalf of a customer who uses SAS Enterprise Guide to import spreadsheet data: The date "12/31/9999" will import as "02Jan****" when reading
When you connect to a SAS environment with SAS Enterprise Guide, are you a single, consistent person? Or do you have more identities than Chevy Chase in Fletch? When you connect to a SAS environment, you can be many people at once: You are logged into your Windows account on
Check out AnnMaria's blog covering what she's learned by being on the bleeding edge: using SAS 9.2 for Windows x64 on a Win7 virtual machine. Also, her short primer on XPT files makes me want to add some native capability into SAS Enterprise Guide. If your goal is to send
As you use the Query Builder task in SAS Enterprise Guide, you might notice that it refers to tables and computed columns using names that are different than you expect. For example, instead of a table named CANDY_SALES_HISTORY, the Query Builder might show t1. This is called an alias, and
Subtitle: An accounting of accounts which, by all accounts, you should hold accountable. With the introduction of the SAS metadata server for use with SAS Business Intelligence, the role of the SAS administrator became more important. In SAS 9.1.3 a number of new standard "accounts" -- user IDs that serve
If you're accustomed to using "shell" commands from within your SAS programs (using the X command or SYSTASK statement, for example), you'll find that those statements won't work when you run your program from within SAS Enterprise Guide. When you try them, you will probably see one of the following
It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query
I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
Graduate and undergraduate students are eligible to apply for the SAS Student Ambassador Program, which covers the cost of travel expenses and registration fees paid to attend SAS Global Forum 2010. What’s the “catch?” You must complete an application and submit a presentation abstract and working draft by midnight October
A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either
The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This
Most modern programmer text editors allow you to see multiple views of the document you're working on. The SAS program editor within SAS Enterprise Guide is no exception, although we've done a pretty good job of hiding this feature. Read on and learn how to easily "divide and conquer" your
Have you ever submitted a SAS program or query only to immediately regret it? It usually happens just as you finish clicking the mouse or lift your finger from the F8 key: you realize that your program has a horrible flaw that's going to make it run for hours or