SAS Enterprise Guide 4.1 to 4.2 migration – I hate blind dates

Struck a problem converting some Enterprise Guide projects from 4.1 (SAS 9.1.3) to 4.2 (SAS 9.2) around date prompts.

The EG projects have a large bunch of custom code nodes (so hate those!) and they are all running some macro’s that use a date prompt.

Of course they work fine in 4.1 but fail in 4.2.

Traced it to a change in the way date prompts work in eG 4.2 via this SAS Support note:

Problem Note 36581: Date and Datetime parameters might cause syntax errors after project migration to SAS® Enterprise Guide® 4.2

Followed the fix below and updated the date variable in the code from &date to “&date”d  and the date is back on!

For example, in earlier versions of SAS Enterprise Guide, the correctly generated %LET statement might be %let datevar = '01jan2009'd;. However, after migrating projects to 4.2, the statement is incorrectly generated as %let datevar = 01jan2009;.

To circumvent the problem, open the query in 4.2 and edit the filter by adding quotes around the parameter. For example, use "&YourDateVar"d for dates, and "&YourDateTimeVar"dt for datetime parameters.

  • Share/Bookmark

Our Information Maps are too dense!

We are still getting the infamous “Parser has reached the entity expansion limit “64,000″ set by the application” when opening large Information Maps.

As per this tech support note:

Problem Note 20991: SAS® Information Maps with more than 999 data items might fail to open with the SAS Information Map Libname Engine (IMLE)
http://support.sas.com/kb/20/991.html

We have applied the hotfix and checked the config and it all applied as per the tech support note, but we still have the issue intermittently.

What we cant work out is we get this scenario:

  • User A opens EG on PC and gets error on info map
  • User B uses User A’s open EG client, reconnects to metadata as themselves and it info map opens ok.
  • User B opens EG on their PC and info map opens ok
  • User A uses User B’s open EG client, reconnects to metadata as themselves and it info map opens ok.

So we deduce that

  • it is not the info map because some people can open it
  • it sis not the server because some people can open it
  • its not users A EG client, because it works for user B
  • its not User A’s metadata security because it works on user B’s PC

So only think I can think of is cached files on the EG side, or memory issues on the server?

But as I said it is intermittent across environments, across users.  The only thing we do know is that it only happens on our very large Information Maps.

Any ideas?

  • Share/Bookmark

SAS Business Intelligence Certification

I’m sitting the beta test for the SAS Business Intelligence certification tomorrow.

The beta version is a 3 hour and 15 minute exam, this is going to be interesting, exciting, scary, nerve racking……

And of course the opportunity has come at the last minute, so the chance to study is zilch!

  • Share/Bookmark

sasInct Portlet – Zone Portlet – Alpha – whats your thoughts?

We have been working on an idea for a new portlet, and I was interested in any feedback from the SAS community.

The idea is to enable users and portal administrators to layout the portal page via standard drag and drop and resize capabilities that you would expect with any Web personalisation (aka portal) capability.

To do this we have built a prototype of a portlet that then allows you to select other portlets and then darg and drop them on the page.  Once you have done that the layout is saved.

As they say a picture is worth a thousand words, so here is a quick and dirty vid:

So what do you think?

  • Nothing but eye candy?
  • Pretty cool, id buy that!
  • mmm nice try but no cigar

Feel free to post a comment if you have one!

  • Share/Bookmark

Are Tabs coming back to SAS WRS 4.3? (Elvis is in the building!)

One of the things we know our users will not like when we move to SAS 9.2 is the removal of the tabs in Web Report Studio 4.2.

They make it so easy to see whats available and we make a lot of use of sections / tabs in our reports to reduce the number of reports we have to maintain.

I heard a rumour that tabs are back in Web Report Studio 4.3 (due out Q34 2010), but havent found any screenshots on the web to confirm this.

If you know let me know and make my users happy.

  • Share/Bookmark

SAS BI Clients 4.3 and SAS 9.3

I caught up with James Foster from SAS Australia last week and got a bit of an insight into where the SAS products are going in the next few months.

At the moment we are at SAS 9.2 M3 for the SAS Platform (eBI, eDI, EM etc).

Later this year (Mid Q3 ish?) a new set of the BI Clients will be released under the 4.3 banner (so Enterprise Guide 4.3, Web Report Studio 4.3 etc). These clients will bring massive enhancements to the BI client functionality.

Two that I have already mentioned are the enhancements Chris has outlined will be coming in Enterprise Guide 4.3 here and the new BI Dashboards James mentioned at SUNZ earlier this year.

To leverage this new functionality you will need to be on SAS 9.2 M3, then install the desktop/developments clients and/or redeploy the new Web App versions.

James also mentioned that SAS 9.3 is currently under development as the next major release and maybe be out sometime next year.

Its great to see we don’t have to wait another 5 years (aka SAS 9.1 –> SAS 9.2) before SAS delivers new capability. I think given the BI competitors SAS (aka Oracle, SAP) have in the market the speed of development is going to be key.

Bring it on!

  • Share/Bookmark

VM Ware Networking Options

How does networking inside a virtual machine work?

Your VMware Fusion virtual machines talk to your network using a virtual network adapter. Inside your virtual machine, the guest operating system (Windows, Linux, etc.) believes that it is equipped with an ordinary (wired) Ethernet card. But Fusion patches this card to your Mac’s regular network connection, regardless of whether it is wireless or wired.

What choices do I have for how my virtual machine connects?

Using Fusion’s Virtual Machine menu, you can choose among bridged mode, NAT mode, and host-only mode. NAT mode is the default.

network-options.png

What do these choices mean, and how do I choose the right one for me?

We’ll examine each of these network modes in turn.

What is bridged mode?

Your home or office network is probably equipped with a router for talking to the Internet. Bridging is a network term that describes extending a network without using a router. When you place your virtual machine’s virtual network adapter into bridged mode, your local wired or wireless network is effectively extended to your virtual machine. Your virtual machine becomes a peer of all the other computers on that network.

bridged1.PNG

Although your virtual machine will connect to your local network using the same hardware your Mac uses, the virtual machine will retain its own fully independent network identity. Mac OS’s networking features cannot tell the difference between your virtual machine and a PC on your local network; Mac OS interacts with them over the network in exactly the same way.

Many users’ Macs get their IP address from their wireless base station or router, using a piece of software built into those devices called a DHCP server. In bridged mode, if the operating system inside your virtual machine (Windows, Linux, etc.) is configured to request an IP address from a DHCP server, your virtual machine will get its IP address from the same DHCP server your Mac uses.

What is NAT mode?

NAT is a network technology that protects one network from another. For example, your router probably also acts as a firewall: it protects your Mac by preventing unknown computers on the Internet from connecting directly to it. The term “NAT” is an abbreviation for “Network Address Translation”; the protection afforded by a firewall works (in part) by the router representing your Mac on the Internet. Your router substitutes its own address for your Mac’s.

nat1.PNG

VMware Fusion’s NAT mode is the same technology, but one layer closer to you. NAT mode protects your virtual machine from the other computers around it by placing the virtual machine on an isolated virtual network. Whenever your virtual machine wants to communicate with your office network or the Internet, it does so through a software firewall. This firewall is a component of VMware Fusion that runs inside Mac OS.

Notice that, in this situation, your virtual machine is not on the same network as your Mac and your router. Compare this to the diagram of bridged mode, in which your virtual machine is a peer of your Mac and your router.

In NAT mode, your virtual machine will get its IP address from a DHCP server supplied by VMware Fusion that runs in Mac OS, just as the firewall does. But this IP address will only be used for relaying communication between your virtual machine and the software firewall; that firewall will represent your virtual machine for its network communication with the outside world. Another way to think about this: from the Internet’s perspective, your virtual machine is sharing your Mac’s IP address.

What is host-only mode?

In host-only mode, your virtual machine is not only protected from your local network and the Internet, but also locked out of them. The virtual machine’s network world is wholly within your Mac.

hostonly1.PNG

Just as in NAT mode, your virtual machine will get its IP address from a DHCP server supplied by VMware Fusion that runs in Mac OS.

How do I choose the right network mode for me?

The right network mode for your virtual machine depends on how you plan to use it. In an office or home-office environment, with network printers and file sharing, bridged mode is probably best, particularly because bridged mode allows your virtual machine to use Apple’s Bonjour technology for finding printers. Windows’s workgroup features need bridged mode; only in bridged mode will a Windows virtual machine’s Network Neighborhood show the other PCs on your local network.

NAT mode is ideal when you want your virtual machine to be protected from other computers on your local network, such as when you are using a public wireless connection. Because, in NAT mode, your virtual machine shares your Mac’s IP address for purposes of external communication, it’s especially ideal for use when you are using a paid wireless service, such as in a coffeehouse or hotel. The use of bridged mode would require you to pay twice: once for your Mac and once for your virtual machine.

Host-only mode is useful for environments where your Mac has no network connection at all, or when you wish your virtual machine to be completely isolated from the rest of the Internet.

That’s a lot of choices. How do I keep them all straight in my head?

Here’s a way to think about the network choices:

Mode Nickname
Bridged Home-office mode
NAT Starbucks mode
Host-only Airplane mode

Can I change from one mode to another?

Yes! But, unless you have configured your virtual machine to use fixed IP addresses, you must tell the operating system inside your virtual machine to release and renew its IP address. Renewing your IP address after you change network modes will automatically contact the correct DHCP server: the one on your local network if you changed to bridged mode, and the one provided by VMware Fusion if you changed to NAT or host-only mode.

To release and renew IP addresses within Windows, open a command prompt using Start -> Run -> cmd . Then, in the command-prompt window, give first this command:

ipconfig/release

then this command:

ipconfig/renew

Rebooting the virtual machine will also cause it to obtain a fresh IP address.

  • Share/Bookmark

SAS 9.2 and Weblogic (10.3 or not to 10.3 that is the question)

I have been doing an install of SAS 9.2 eBI using Weblogic.

In all the SAS 9.2 install documentation from SAS it mentions Weblogic 9.2, but if you check out:

Oracle WebLogic Server Support for SAS 9.2

You will see Oracle Weblogic 10.3 is supported.  And when you download the install depot from SAS it will actually downloads Weblogic 10.3 in the thirdparty directory for you.

But when you follow the instructions and try and do the install you will probably get an error when the Install Wizard is configuring the web packages.

If you check the install/configure logs you will see this error:

Problem invoking WLST – ava.lang.UnsupportedClassVersionError:
Bad version number in .class file

It seems although the install screen asks you for a location to the 1.5 version of the JDK, you actually need the 1.6 version of the JDK for it to work with Weblogic 10.3, according to this tech support note:

Usage Note 36538: The SAS® Deployment Wizard fails when you use Java Development Kit 1.5 with Oracle WebLogic Server 10.3

So when going through the wizard, point to the JDK 1.6 and you are away.

  • Share/Bookmark

SAS 9.2 Maintenance Release 3 is out

SAS have issued the 3rd maintenance release to the SAS 9.2 software.

You can find a list of bugs / issues / unplanned features that have been resolved here:

Issues Addressed in SAS 9.2 (TS2M3)


  • Share/Bookmark

Deleting Channel Content in SAS 9.1 – Begone damn spot!

We are doing some work to enable Channels and WRS report scheduling in our SAS 9.1.3 environment.

Its a complete mare!

One of the issues we have struck is the inability to delete any packages you have published to a channel.  They just stay there forever.

In SAS 9.2 you get a utility that lets you delete these packages:

SAS 9.2 Using the Package Clean-Up Utility to Remove Packages

Luckily the friendly chaps at SAS tech Support mentioned that there is a SAS Toolpool entry for 9.1.3 that does teh same function.

So if you need to delete Archived Packages in SAS 9.1.3 channels, then as your friendly SAS dude for the toolpool entry.

  • Share/Bookmark