o

Problem Notes for SAS®9 - 65916: Accessing a Google BigQuery table without including the SCHEMA= option in the LIBNAME statement might result in an error

When you issue a LIBNAME statement for a Google BigQuery database without including the SCHEMA= option, all tables in the project are shown when the libref is expanded. However, if you try to acces




o

Problem Notes for SAS®9 - 65935: The UNICODE function does not support Numeric Character Representation (NCR) for a surrogate pair

Using the NCR form of a surrogate pair as an input string to the UNICODE function does not convert the string to the appropriate display character.




o

Problem Notes for SAS®9 - 65031: Grid options set mappings are returned based on which option set is the first in the metadata search chain

When users are defined in multiple groups associated with grid options set mappings, the first grid option set that is returned by the metadata search chain takes precedence. Only one grid options set mapping is used




o

Problem Notes for SAS®9 - 34294: A missing discrete dependent variable in the selection model together with a OUTPUT statement might cause an Access Violation error

If the following conditions are met in PROC QLIM: the SELECT option and DISCRETE option are specified in the same MODEL statement or ENDOGENOUS statement the same dependent variable with S




o

Problem Notes for SAS®9 - 65927: The Copy Files task in SAS Enterprise Guide 8.2 fails with the message "ERROR: Target folder does not exist or cannot be accessed"

When you run the Copy Files task in SAS Enterprise Guide and there is no connection to a SAS server, it fails with the following error: "ERROR: Target folder does not exist or cannot be accessed."




o

Problem Notes for SAS®9 - 65903: You see a "java.lang.IllegalArgumentException" error in the log file when you use the IFRS9_Cycle workflow template in SAS Solution for IFRS 9

The problem occurs on a content release on the SAS Risk Governance Framework.




o

Problem Notes for SAS®9 - 65872: You see a "java.lang.IllegalArgumentException" error in the log file when you use the CECL_Cycle workflow template in SAS Solution for CECL

The problem occurs on a content release on the SAS Risk Governance Framework.




o

Problem Notes for SAS®9 - 65904: SAS Federation Server stops responding when you run queries against X_OBJECT_PRIVILEGES in SYSCAT and the queries run for hours

The select * from "SYSCAT"."SYSCAT"."X_EFFECTIVE_OBJECT_PRIVILEGES" query runs for hours. In this scenario, SAS Federation Server stops responding, making it unavailable for use. Restarting SAS Federation Server solves t




o

Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause

When you query an Oracle table and use the LIMIT clause using either SAS  Federation Server or FedSQL, a row limit is not passed to the database. In this scenario, a Full Article



o

Problem Notes for SAS®9 - 65914: You see the error "Driver does not support this optional feature" after trying to insert or append data to a Databricks table

You can create create a Databricks table by using PROC SQL, but you cannot insert data into the table. PROC APPEND cannot create a new table or append data to an existing table.




o

Problem Notes for SAS®9 - 65574: Decimal values are rounded after they are inserted into a new Databricks table via SAS/ACCESS Interface to JDBC

A DATA step and PROC SQL can round numeric values while creating and loading data into a new Databricks table via JDBC.




o

Problem Notes for SAS®9 - 65886: Trying to bulk load data into a Google BigQuery database might result in an error

When you bulk load data into a Google BigQuery database, you might encounter this error: "Error while reading data, error message: CSV table encountered too many errors, giving up...Error detected while parsing row starting at position: 0...Data




o

Problem Notes for SAS®9 - 65898: A misleading SASTRACE message appears in the log when you insert a row into an Oracle table using SAS/ACCESS Interface to Oracle with DBIDIRECTEXEC

When you add one row to an Oracle table using DBIDIRECTEXEC, you see the following misleading trace message: "ORACLE: 4294967296 rows inserted/updated/deleted." You should see something similar to the following: "ORACLE: 1 rows inserte




o

Problem Notes for SAS®9 - 65909: SAS Visual Analytics Designer 7.5 responds slowly when you edit large or complex reports

If your SAS Visual Analytics report contains many sections and objects, you might encounter performance problems when you are editing the report.   A hot fix is planned for this issue.




o

Problem Notes for SAS®9 - 64980: The PRINT procedure contains a buffer-overrun vulnerability

Severity: Medium Description: PROC PRINT might fail with a buffer overrun when you submit it in conjunction with certain malformed SAS statements.



o

Problem Notes for SAS®9 - 64550: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter

Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact:




o

Problem Notes for SAS®9 - 65893: Custom sorts are sorted incorrectly when they are used in a hierarchy in SAS Visual Analytics Designer

A custom sort might be sorted incorrectly when the data item is used in a custom category, which is then used in a hierarchy. The issue can occur in the following scenario:




o

Problem Notes for SAS®9 - 65844: STRESS task fails with "Fatal error in PMPI_Bcast: Other MPI error, error stack: PMPI_Bcast(1478)"

In SAS  High-Performance Risk, a STRESS task might fail with a message like the following in the SAS log while the compute server is sending the ScenarioCF/Value data to the HPRisk Engine:



o

Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows

A set of PROC SQL queries that create a view, contain a constant column, contain a computed column, and a create a table do not generate a unique set of rows in the table that is created.




o

Problem Notes for SAS®9 - 65597: An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results

An issue occurs when code contains a complex SQL procedure query with a WHERE clause that contains multiple subselects. Incorrect results might be returned. Click the Hot Fix tab in this note to




o

Problem Notes for SAS®9 - 65572: The length of a string variable might be longer than specified with the MAX_CHAR_LEN= option

When you read in a BigQuery table, the length of string variables might be longer than the length specified with the MAX_CHAR_LEN= option when running your SAS software   with UTF-8. By




o

Problem Notes for SAS®9 - 65883: SAS Workflow Studio returns a "cannot load" error when you try to open the CECL_Cycle_AFS workflow template for SAS Solution for CECL

You might see the following error in SAS Workflow Studio when you try to open the CECL_Cycle_AFS workflow template that is shipped with SAS Solution for CECL:



o

Problem Notes for SAS®9 - 65856: The process of updating a lookup table in SAS Business Rules Manager (running in UNIX operating environments) does not work properly

Under UNIX, the process of updating a lookup table in SAS Business Rules Manager does not work properly. The problem occurs when you perform these steps:  Open a lookup table. Cl




o

Problem Notes for SAS®9 - 65869: SAS Visual Data Builder does not enable you to schedule with multiple time-event triggers

SAS Visual Data Builder might not enable you to create multiple time-event triggers. The + button to add another trigger is not available to select, as shown in the following display: imgalt="" src="{fusion_658




o

Problem Notes for SAS®9 - 65868: Saving a report distribution in SAS Visual Analytics Designer fails with "The name is invalid"

When you attempt to save a report distribution in SAS Visual Analytics Designer, you might see the error shown in the following display:  imgalt="" src="{fusion_65868_1_distributionerror.png}" />



o

Around the Horn: Pham, Choi aim to boost Rays

Over the past couple of weeks leading up to Spring Training, MLB.com went around the horn to examine each area of the Rays' 2019 roster. The final installment focuses on Tampa Bay's outfield and designated hitters.




o

Here's your guide to Rays Spring Training

Baseball season is now on the clock and the Rays are looking to get back to the postseason for the first time since 2014. That quest will begin next week as Spring Training is finally upon us. Here's a primer to get you informed on all you need to know this spring.




o

Inbox: How will potential new rule affect Rays?

Rays beat reporter Juan Toribio answers fans' questions.




o

Rays' 2019 mantra: Prepare to win from within

Over the past couple seasons, the Rays have preached patience as the organization provided time for the top prospects to make it up to the Majors. Now, the focus has been primarily in remaining flexible and keeping positions open for the young talent arriving from the Minors.




o

Bulked-up Duffy looks to sustain at plate in '19

As Matt Duffy entered the offseason, he knew that he needed to add strength in order to hold up over the course of a 162-game season. The 28-year old has been at the Rays' Spring Training facility in Port Charlotte, Fla., for about a week, and he believes his improved shape will help the team fight for a playoff spot in 2019.




o

Predicting Rays' Opening Day roster

Here's an early look at how the Rays' 25-man roster could shape up on Opening Day.




o

Uniform patch to mark 150 years of pro baseball

All 30 Major League teams will wear special "MLB 150" patches on their uniforms for the entire 2019 season in honor of the 150th anniversary of the 1869 Cincinnati Red Stockings, the first openly all-salaried professional baseball team.




o

30 low-key acquisitions who could pay off big

Fans and analysts spend the entire offseason speculating where the top free agents could go, but sometimes an under-the-radar pickup can end up making a world of difference. As positional competitions begin to heat up at Spring Training camps this month, MLB.com's beat writers were asked to identify one potentially overlooked acquisition for each of the 30 clubs. Here's who they came up with.




o

Rays two-way prospect McKay to DH only in '19

Brendan McKay is still going to be a two-way player, but the Rays are planning to narrow his focus on the hitting side by keeping him to designated hitter-only duties, a source confirmed to MLB.com's Juan Toribio on Monday.




o

Morton believes Rays can make postseason

After a pair of seasons -- and a World Series title -- with the Astros, Rays pitcher Charlie Morton is confident that his new team has what in takes to make a postseason run in 2019.




o

A little rain can't keep eager Rays from field

A rainy morning didn't stop the Rays' pitchers and catchers from officially taking the field Wednesday. "Other than the pitchers getting out there and getting in their legs a little bit and running some of the more casual [pitchers' fielding practice drills], everything is fine," manager Kevin Cash said.




o

Snell not feeling pressure in '19 after Cy win

After winning the 2018 American League Cy Young Award, Blake Snell said he doesn't feel "any pressure" in '19.




o

Spring brings vet leaders for blossoming Rays

When Tyler Glasnow heard the news that the Rays were signing Charlie Morton, he couldn't help but get even more excited for the 2019 season.




o

Prospects who should vie for a roster spot

The 30 prospects below all are getting very long looks this spring with an eye toward breaking camp with the parent club. Even if they start the year in the Minors, they all should get the chance to contribute at some point in the very near future.




o

Pagan working to develop off-speed pitches

As Emilio Pagan enters his first Spring Training with the Rays, he's looking to prove that he can perform well against hitters on either side of the plate.




o

Prospect Poche making strong first impression

Colin Poche's fastball won't light up the radar gun, but it proved to be one of the most effective pitches in the Minors last season.




o

Faria enters camp fighting for bullpen spot

After a disappointing 2018 season, Jake Faria is looking to show that last season isn't reflective of the type of pitcher he is.




o

Glasnow working to quicken delivery

Tyler Glasnow is hoping to build off a positive 2018, but his delivery is going to look a little different this season.




o

Rays' Top 30 Prospects list

Who do the Rays have in the pipeline? Get scouting reports, video, stats, projected ETAs and more for Tampa Bay's Top 30 Prospects on MLB Pipeline's Prospect Watch.




o

Kiermaier eyeing 'huge rebound year' in 2019

Kevin Kiermaier has always played with a chip on his shoulder, but he admits that there's some extra motivation heading into Spring Training after a frustrating 2018 season.




o

Reasons for optimism for each MLB club

On this opening week of Spring Training, all 30 Major League teams have one thing in common: optimism. Here's an optimism cheat sheet for each of them.




o

The Rays' Spring Training battle to watch

The next five weeks will see lots of shuffling on Major League rosters. Here are the most intriguing positional battles on each of the 30 MLB clubs.




o

Here are 10 Rays players to watch this spring

While most of the attention will fall on the players who are expected to make the Opening Day roster, manager Kevin Cash and the rest of the organization will be keeping a close eye on some of the players that could find their way to the big leagues at some point within the next year.




o

Diaz aims to turn heads, cement everyday role

When Yandy Diaz arrived at Rays camp on Sunday, he quickly established himself as the most muscular player inside the clubhouse. During Spring Training, his focus will be to establish himself as an everyday player.




o

Cash reminder: Stay focused on the now

All 66 players on the Rays' Spring Training roster took the field Monday as Tampa Bay went through its first full-squad workout.