Recent SAS Notes
SAS Notes for SAS®9 - 40470: SAS BI Dashboard cannot access relational databases by using a metadata table data source
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

