I’m tired. But in a good way. We had a great day in the SAS Publishing booth. We had a lot—and I do mean a lot—of traffic in the booth, much of it thanks to the early-bird book giveaway special. And I got to talk to a lot of cool
With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below: SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a
VP of Platform R&D; at SAS (also known as @hornpolish to SAS Twitterers) presented the Keynote at the SAS SouthEast SAS Users Conference #sesug09 on Sunday Evening, topic = How to Get and Keep SAS Users Happy. The main tint of the presentation was how to keep the computer happy.
I had every intention of blogging daily from M2009 and PBLS, but I never found a free moment yesterday to write down anything. I don’t like to think about it because it makes me exhausted, but I think I stayed awake for 24 hours yesterday. After a delay in Dallas,
Yesterday I attended a virtual talk by Bob Rodriguez on his famous topic: ODS Statistical Graphics in SAS 9.2. You can learn lots of details by reading his paper. Bob's paper shows examples of the graphs you can get, how to control their appearance, and what SAS syntax to use.
Nothing can stop the man with the right mental attitude from achieving his goal; nothing on earth can help the man with the wrong mental attitude – Thomas Jefferson How true this saying is for all of us in various situations. Our study group met this week for the second
(SESUG2009 Paper Preview) As I mentioned so many years ago (check my 2005 post out "The great analogy of SAS BI Products"), SAS offers a wide range of products for various users to get what they need and do what they must do. Due to this, I relate the various
Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one
For OLAP Cube Developers to gain access to SAS 9.2, two items: 1. Authorizing Access to SAS OLAP Servers from SAS http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/a003311504.htm "Users of SAS OLAP Cube Studio need readMetadata and writeMetadata permissions. To read and update the authorizations for SAS OLAP Servers, follow these steps: 1.Open SAS Management Console.
I arrived at work this AM to see a link to this blog featured as part of the sasCommunity.org Tip of the Day. If you clicked on that link and landed here, welcome! I hope it was worth the click. Please, make yourself at home and browse through the 2
A customer posted on the discussion forum that, much his dismay, SAS Enterprise Guide sets the NOFMTERR option automatically when connecting to a SAS session. The FMTERR|NOFMTERR option specifies whether SAS should report an error when you attempt to reference a data column that has a SAS format applied, but
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
Just a quick tip on the shared prompts in SAS Information Map Studio: When attempting to select a previously created prompt in Information Map Studio, SAS will only display shared prompts that can be used for the type of variable you are filtering/prompting. For example, if you have a date value
Contibuted by Brenda Kalt, Development Tester, Publications Product Testing I work in Publications, and I'm looking at “PROC CERTIFY;” from the other side of the mountain. In September I took the exam and passed it comfortably. I reviewed three nights before taking it (generally missing what I should have read
Included are a few of my favorite things about the new OLAP Server (for SAS 9.2 EBI Installations). Export/Import via SAS spk file The .spk files are packages that contain everything needed to export from Development and import into Production. This is an IDEAL way to reduce dev-test-prod interactions on the
I found this excellent example of What Not To Do on graphjam.com. I was inspired to see if I could recreate something similar in SAS. You see the result here. Yes, the PIE3D statement is ready to do your bidding. If that's what you really want.
If you are heavy Add-in to MS Office users and are looking to upgrade to SAS 9.2, now is the time! The new maintenance release of SAS provides a much needed fix for Add-in to MS Office. Found that in the last release (TS2M0), Add in users were unable to
Let me just say, I am loving SAS 9.2 and it's functionality for cascading prompts. I created a dynamic list prompt (the icing to that cake by the way) pointing to a sas dataset that has two variables: County and City. In Prompt #1, I created a County Selection pointing
There are some things about forecasting that you may only discover by being a forecaster. Simply managing a forecasting process, or being a downstream consumer of the forecast, isn't always enough. If you have something to say to your management about forecasting, but would rather avoid the confrontation, maybe we
Starting on September 1st, covering every working day, I began a thirty day challenge (twitter #30dchallenge) to accomplish a couple of goals: 1. Continue to increase my skills/knowledge of the new SAS 9.2 System Topics included both versions (SAS 9.1.3 and SAS 9.2), multiple components (SAS Enterprise Guide, SAS Management
Along with hundreds of SAS users, Alison (of sas.com fame) is attending the MidWest SAS User Group meeting. She recently "live-blogged" the keynote presentation from Suzanne Gordon, our CIO. Suzanne does us proud every time. Check out what she had to say to the MWSUG attendees about her start at
After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (https://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the 'Server List', there is a small blue circle with a 1-2-3 and when you mouse over you will see 'Prompt Manager'. When adding
Have you seen that new show Glee? It is a musical-comedy about a glee club struggling to survive in a cheerleader-dominated world. Fox describes it as “a new comedy for the aspiring underdog in all of us.” I’m feeling like an aspiring underdog these days. But, like the kids in
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
Included are several of the key elements of the new Configuration Manager Plugin that I heart. 1. Modifying the Web Connection Information One of the MAIN items I love about the new version is the ability to modify the configuration of the Web Applications WITHOUT redeploying all the war files. You
Hmmm. Let’s see. Facebook. Check. Twitter. Check. LinkedIn. Check. That’s about it for me, social media Website-wise. Guess I got that covered. What? You say there’s more? Lots more? Boy, is there ever. Wikipedia lists 157 active social networking sites. My favorite in that bunch, which I’ve not been quite
There are a couple of options with getting SAS Stored Processes to access Metadata Libraries. 1. Pre-Assignment of Libraries or Connecting as a Single (and therefore Shared) SAS User Account The pre-assignment of libraries means that when the Object Spawner is initiated, the libraries are made available to the end
(SAS 9.2) To get the SAS BI Dashboard to work appropriately, the users who have Role level access to modify and create Dashboards MUST also have read/execute/write access to the BIDashboard configuration folder (example of this location: C:SASEBIserverLev1AppDataSASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is
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
I have visited Oslo, Norway’s Vigeland Park and also have a postcard in my office of the little Angry Boy (Sinnataggen) statue and it reminds me of the frustration I have occasionally felt while attempting to teach myself SAS programming. There are times when I want to mimic this little’s
