SAS S-Notes

S-Notes from SAS Institute will give you an overview of knowledgebase notes and possible hotfixes for different SAS-products.

http://support.sas.com/techsup/news/snotes.html

The mail that you will receive on a daily basis will look something like this. It is not possible to subscribe to specific SAS-products. All SAS-products is contained in the mail.

SNOTES-L update for 27JAN2012

****************************
New or Revised SAS Notes
****************************

product = Base SAS

43817  – A %INCLUDE statement for an externally allocated data set might fail in the z/OS environment
Release(s) Reported:
Release(s)    Fixed: 9.3
Date        Created: 25JUL2011
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/43817.html

45507  – FILEEXIST causes an infinite loop on Unix if path equates to the root directory
Release(s) Reported: 9.21_M3
Release(s)    Fixed:
Date        Created: 26JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45507.html

45503  – Metaserver and metaport options are not valid with the SAS Information Maps LIBNAME engine when the code is included in a SAS Stored Process
Release(s) Reported: 9.21
Release(s)    Fixed:
Date        Created: 26JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45503.html

product = SAS Add-in for Microsoft Office

45501  – Information maps with incorrectly truncated data item names cannot be opened in SAS Enterprise Guide and the SAS Add-In for Microsoft Office
Release(s) Reported: 4.3
Release(s)    Fixed:
Date        Created: 26JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45501.html

product = SAS Enterprise Guide

45501  – Information maps with incorrectly truncated data item names cannot be opened in SAS Enterprise Guide and the SAS Add-In for Microsoft Office
Release(s) Reported: 4.3
Release(s)    Fixed:
Date        Created: 26JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45501.html

product = SAS Financial Management

45359  – Number formatting styles might be ignored in SAS Financial Management reports or data-entry forms
Release(s) Reported: 5.2
Release(s)    Fixed: 5.3
Date        Created: 11JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45359.html

45320  – Red/pink cells displayed in SAS Financial Management Web-based data entry form
Release(s) Reported: 5.2
Release(s)    Fixed: 5.3
Date        Created: 09JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45320.html

45367  – Time dimension is not drillable in a SAS Financial Management Web data entry form
Release(s) Reported: 5.2
Release(s)    Fixed: 5.3
Date        Created: 11JAN2012
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/45367.html

product = SAS Warranty Analysis

41253  – SAS Warranty Analysis rich client launch fails with Error: Unexpected exception: java.lang.NullPointerException
Release(s) Reported: 4.2
Release(s)    Fixed:
Date        Created: 15OCT2010
Date   Last Updated: 26JAN2012
http://support.sas.com/kb/41253.html

Search SAS Problem Notes, Usage Notes, and Samples on the Technical Support Web Site:
You can go to SAS Institute’s Technical Support web site search page at:
http://support.sas.com/kb
to search for these and other notes. Alternatively, if your mail program
allows it, you can simply click on the url below the title to view them
via your browser.
==============================

===================================================Problem/Question Submission:
You can submit questions or problems SAS Institute’s Technical Support
web site at:
http://support.sas.com/ctx/supportform/index.jsp
=================================================================================Unsubscribing from the SNOTES-L Listserv:
To unsubscribe you can send mail to LISTSERV@LISTSERV.SAS.COM with:
‘SIGNOFF snotes-l’
as the only text in the body of the message (without the single quotes).
You can also unsubscribe via the web at:
http://support.sas.com/techsup/news/snotes.html
=================================================================================Supportively,
SAS Institute Technical Support

 

 

OS Scheduler in SAS Management Console (SMC)

Defining an operating system scheduling server in the metadata repository

  1. In SAS Management Console, right-click Server Manager and select New Server. Fill out the next windows of the wizard with this information:
    a. Scheduling Servers: Operating System Services
    b. Scheduling server name: OS Scheduling Server
    c. SubType: Windows
    d. Control Directory: eg. C:\SAS\Config\Lev1\SchedulingServer
    e. Command: eg. C:\SAS\Config\Lev1\SchedulingServer\SchedulingServer.bat
    f. Object Server Parameters: applevel=2
    g. Authentication Domain: DefaultAuth
    h. Host Name field: <Server>
    i. Port number: 8451
    j. Select Finish when you have entered all the necessary information.

Associating the operating system scheduling server with a spawner definition

  1. In SAS Management Console, right-click the object spawner defined in Server Manager and select Properties.
  2. In the Spawner Properties dialog box, select the Servers tab.
  3. From the Available Servers list, select the operating system scheduling server and move it to the Selected Servers list.
  4. Click OK.
  5. Restart the services for the object spawner eg through services.msc on the OS.

It might also be nessessary to allow inbound connections in OS firewall on port 8451 (this port might be different on your SAS-system).

Partitioning in Microsoft SQL-server 2008

When partitioning tables in Microsoft SQL-server 2008 you could get this error when your trying to move to the next step after mapping your partitions.

The number of filegroups or range values is not valid. Enter an extra filegroup in addition to the number of boundary values.

Your partition mapping will probably look something like this.

The error occurs because you haven’t choosen a filegroup for the last empty partition (the one after 2011). Your partition mapping should look like this.

In SQL the partition function will look like this.

CREATE PARTITION FUNCTION [<pf_Year>](varchar(4))
AS RANGE RIGHT
FOR VALUES (N’2007′, N’2008′, N’2009′, N’2010′, N’2011′)

Tablesample

This SQL-sentence will first of all create a table (destinationtable) containing variable1, variable2 and variable3. Into the destinationtable it will make a tablesample from 10 percent of the observations in the soucetable.

SELECT [variable1]
,[variable2]
,[variable3]
into [databse].[schema].[destinationtable]
from [database].[schema].[sourcetable]
tablesample (10 percent)

You could eg. use tempdb (a temporary database in Microsoft SQL-server) to store the sample.

ILMerge and automated program transfer

Incorporating the DevExpress components in your executable can be done using ILMerge. In my case ILMerge is run through a .bat-file and works like this :

.\ILMerge\ILMerge.exe /targetplatform:v4 /target:winexe /out:.\OutputDir\mss.exe mss.exe .\DevExpress\DevExpress.BonusSkins.v11.1.dll .\DevExpress\DevExpress.Data.v11.1.dll
.\DevExpress\DevExpress.OfficeSkins.v11.1.dll .\DevExpress\DevExpress.Printing.v11.1.Core.dll
.\DevExpress\DevExpress.Utils.v11.1.dll .\DevExpress\DevExpress.XtraEditors.v11.1.dll

It takes mss.exe and the DevExpress DLL’s and merges them into one executable .\OutputDir\mss.exe

Right after that .\OutputDir\mss.exe is compressed using 7zip.

.\7zip\7z.exe a .\OutputDir\mss.zip .\OutputDir\mss.exe

And finally it is transferred to the website using WinSCP. I’m using Windows XP and as far as I know the build in ftp-client doesn’t support passiv FTP. I believe that ftp-clients in later versions of Windows does support passiv FTP. So if your using a later version than XP of Windows. You can do essentially the same thing with the build in ftp-client. But if your using XP and is connecting to a passiv FTP-server, you can use WinSCP.

.\FTP\winscp.exe /script=”.\FTP\script.txt”

Script.txt looks like this:

open <session in WinSCP>
option confirm off
put “.\OutputDir\MSS.ZIP” “/Programs/MSS.ZIP”
exit

“Options confirm off” lets you overwrite a file without being prompted. You also need to create a session in WinSCP (GUI) or else you will get the following message:

Automatic actions are disabled when URL address is provided on command-line.