SAS Access – Who plays nicely with who(m)

Just saw this post on Chris H’s blog here and I am replicating it so I can find it when I need it. (cause half my posts are there so I can find them when I need them)

If you want to know what version of SAS/Access works with what operating system and what release and what database etc, then look here:

http://support.sas.com/matrix/list?SAS=All&Engine=All&OS=All&googleTrack=on

  • Share/Bookmark

SAS 9.2 Sample Install Plans

When installing SAS 9.1.x from a software depot, you needed to have an Install Plan and the only people who could generate these were SAS employees.

For SAS 9.2 there are now sample install plans available on the SAS  site here:

http://www.sas.com/installcenter/plans

Of course I was looking for a STM install plan, which isn’t there but that is different issue ….

  • Share/Bookmark

SAS Management Console 9.1.3 – Invalid Templates

Its been a full on week what with the SAS 9.2 migration and a whole lot of other work happening on another project.

Also this week I seem to have been shown a lot of tips and tricks I didn’t know you could do.

One of them was found by Rob and passed on to me (thanks Rob).

The issue was in SAS 9.1.3 Management Console and related to some of the screens not having all the relevant fields displayed.  As an example the Libname edit screen might be missing the field where you normally define the file path.

The fix was to go into the Metadata Manager > Resource Templates tree in SMC and delete the relevant template.

Then logout of SMC and log back in and SAS will automagically re-create a new template, and it will be valid.

  • Share/Bookmark

SAS 9.2 – A Read-access violation

In the middle of my first production SAS 9.2 upgrade (yeeehaaaaa).

After SAS had finished the install we manually converted the relevant metadata etc.

We then used the EG Migration Wizard (more on this in another post) and then tried to run the project.

Code that used to run fine in SAS 9.1 gave an error like this in SAS 9.2:

ERROR:  Read Access Violation In Task [ SQL ]
Exception occurred at (032F94F6)
Task Traceback

After applying the hotfix here: http://support.sas.com/kb/37/012.html  to the server it ran fine.
  • Share/Bookmark

SVG is cool

SPM 1.4 was based around an XML as the backend and for the frontend HTML and from memory SVG.  In SPM 2.x you can publish diagrams in SVG as well.

The cool thing with SVG is that the images are all created based on txt files with location and colour information.

Check this one out:

http://www.degrafa.org/source/Car/Car.html

Then right click and look at the source, nothing but txt cool!

Pity SVG is not more widely adopted, but then with the advent of flash and flex and there navigation abilities, I suppose it is not surprising.

  • Share/Bookmark