Recent SAS Notes

Syndicate content SAS Institute Inc.
SAS Notes for SAS®9 - published to the web in the last 14 days.
Updated: 1 hour 53 min ago

SAS Notes for SAS®9 - 40470: SAS BI Dashboard cannot access relational databases by using a metadata table data source

Mon, 08/09/2010 - 16:50
In order to access tables from relational databases, you must use information maps. If you select a metadata table data source, you will see the following error.

SAS Notes for SAS®9 - 40407: Understanding how SAS Web Report Studio exports formats for measures and dimensions

Thu, 08/05/2010 - 12:06
When building a cube, you can specify a format for a measure. For example, you might specify a format of COMMA20.0 for a measure. You can also specify a format for a dimension by using the FORMAT_STRING property. For exa

SAS Notes for SAS®9 - 39487: How to migrate SAS Enterprise Miner(tm) project folders from 32 bit to 64 bit, or to a different operating system

Wed, 08/04/2010 - 15:13
When you migrate SAS Enterprise Miner from a 32 bit operating system to a 64 bit operating system, or when you move projects to a different operating system platform (for example, Windows to UNIX, Windows to Linux), you mu

SAS Notes for SAS®9 - 40505: Xythos-based SAS Drug Development Desktop Connection (SDDDC) is not supported in Citrix environment

Tue, 08/03/2010 - 17:43
The Xythos-based SAS Drug Development Desktop Connection (SDDDC) is not supported in a Citrix or Windows Terminal Services environment. Incorrect results may be experienced by users if this is attempted. There are no plans for the SDDDC to support

SAS Notes for SAS®9 - 34549: SAS Revenue Optimization Suite and SAS Size Optimization Suite AIX upgrade compatibility

Tue, 08/03/2010 - 13:09
SAS ® Revenue Optimization Suite (SAS Markdown Optimization, SAS Regular Price Optimization, SAS Promotion Optimization) and SAS ® Size Optimization Suite (SAS Size Profiling and SAS Pack Optimi

SAS Notes for SAS®9 - 37482: Setting up SAS software to read Simplified Chinese data

Tue, 08/03/2010 - 12:17
To enable SAS to read Simplified Chinese data, you must set the DBCSLANG system option to a value of Chinese and change the regional and language options for you

SAS Notes for SAS®9 - 36480: New CMISS function in SAS® 9.2 makes it easier to count missing values across observations

Mon, 08/02/2010 - 16:33
The new CMISS function in SAS 9.2 makes it much easier to count missing values on each observation of a SAS dataset. Prior to this, you needed to use multiple lines of code to accomplish what a single line does in 9.2 a

SAS Notes for SAS®9 - 36198: New function GEODIST in SAS® 9.2 returns the geodetic distance between two latitude and logitude coordinates

Mon, 08/02/2010 - 16:32
In SAS 9.2 the new GEODIST function will return the geodetic distance in kilometers or miles. Kilometers is the default, but by selecting the option M as documented, you can get the distance in miles. The de

SAS Notes for SAS®9 - 33352: There is a new option in SAS® 9.1.3 for the COMPRESS function that provides more flexibility when removing various characters from a string

Mon, 08/02/2010 - 16:27
The new option MODIFIER allows for more flexibility in compressing out various types of data from a character string. In the Full Code tab are a few samples using some of these modifiers. Prior

SAS Notes for SAS®9 - 33137: Finding what SAS® considers punctuation, and compressing them out easily in SAS 9.1.3 and above

Mon, 08/02/2010 - 16:26
The code below shows how to determine what SAS considers punctuation by using the ANYPUNCT function and a loop. It also shows how to compress out all punctuation from a string using the new P option for the COMPRESS fun

SAS Notes for SAS®9 - 32165: The message in the SAS® log has changed for FUNCTION OPTNAME in SAS 9.2

Mon, 08/02/2010 - 16:25
The code included in this note generates different results in SAS 9.2 than it did in previous releases. Development was asked to change some messages to make them more accurate, and this was one of the changes that was m

SAS Notes for SAS®9 - 32040: New options available for the SCAN FUNCTION in SAS® 9.2

Mon, 08/02/2010 - 16:25
There are two new options that can be used with the SCAN FUNCTION beginning in SAS 9.2. They are charlist and modifier. The details are below. charlist Charlist specifies an o

SAS Notes for SAS®9 - 31609: HOLIDAY FUNCTION is available to all BASE users beginning in SAS® 9.2

Mon, 08/02/2010 - 16:24
The HOLIDAY FUNCTION moved from SAS High-Performance Forecasting to BASE software and is now available to all BASE software users beginning in SAS 9.2. This will make it much easier to determine many of the c

SAS Notes for SAS®9 - 40496: The SCANQ function is no longer documented in SAS 9.2 and above

Mon, 08/02/2010 - 15:43
The function is still available for use, but according to development the functionality that was part of that function has been incorporated into the SCAN function. It would be a good idea to use the SCAN fun

SAS Notes for SAS®9 - 32205: Converting SAS/IntrNet code to a SAS Stored Process

Wed, 07/28/2010 - 12:59
Most SAS/IntrNet programs can be converted to and then run as a stored process without having to change any code. For more information about this conversion and possible issues, see http://support.sas.com/rnd/i

SAS Notes for SAS®9 - 40422: Functionality is added to SAS/ACCESS Interface to Aster nCluster to use control characters for delimiter and quote characters when bulk loading

Tue, 07/27/2010 - 16:16
Functionaly is added to SAS/ACCESS Interface to Aster nCluster to use control characters for the delimiter and quote characters when bulk loading. New data set options BL_ESCAPE=<

SAS Notes for SAS®9 - 39985: French updates are available for SAS Anti-Money Laundering 4.2

Mon, 07/26/2010 - 17:20
Translation updates for the French language are available for SAS Anti-Money Laundering 4.2. The updates are to the Help system only.

SAS Notes for SAS®9 - 39967: French translations not available in SAS Anti-Money Laundering 4.2

Mon, 07/26/2010 - 17:17
After installing AML 4.2 Some table translations are not available. Manual editing is necessary for antimnyldncf_config.xml to surface french translation

SAS Notes for SAS®9 - 40421: Aggregation type used for a calculated measure does not control whether SAS Web Report Studio generates a total

Thu, 07/22/2010 - 11:00
In SAS size="-1">® Information Map Studio, calculated measures use one of the following aggregation types: Defined in expression (non-additive) Defined in expressi

SAS Notes for SAS®9 - 40390: Shared prompts might not be available to select for a filter in an OLAP-based SAS Information Map

Wed, 07/21/2010 - 11:50
In order to use a shared prompt in an OLAP-based information map, the prompt must meet the following requirements: The Prompt Type is OLAP member . The Data Source for the