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 By feedproxy.google.com Published On :: Wed, 6 May 2020 09:41:22 EST 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 Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
o Problem Notes for SAS®9 - 65935: The UNICODE function does not support Numeric Character Representation (NCR) for a surrogate pair By feedproxy.google.com Published On :: Wed, 6 May 2020 09:33:48 EST 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. Full Article BASE+Base+SAS
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 By feedproxy.google.com Published On :: Tue, 5 May 2020 15:04:46 EST 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 Full Article GRIDMGR+SAS+Grid+Manager
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 By feedproxy.google.com Published On :: Tue, 5 May 2020 13:04:13 EST 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 Full Article ETS+SAS/ETS
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" By feedproxy.google.com Published On :: Tue, 5 May 2020 09:59:15 EST 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." Full Article EGUIDE+SAS+Enterprise+Guide
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 By feedproxy.google.com Published On :: Fri, 1 May 2020 18:01:29 EST The problem occurs on a content release on the SAS Risk Governance Framework. Full Article RGPBNDL+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 By feedproxy.google.com Published On :: Fri, 1 May 2020 16:53:01 EST The problem occurs on a content release on the SAS Risk Governance Framework. Full Article RGPBNDL+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 By feedproxy.google.com Published On :: Fri, 1 May 2020 14:48:24 EST 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 Full Article DFFEDSVR+SAS+Federation+Server
o Problem Notes for SAS®9 - 65682: Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause By feedproxy.google.com Published On :: Fri, 1 May 2020 14:43:59 EST 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 DFFEDSVR+SAS+Federation+Server
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 By feedproxy.google.com Published On :: Fri, 1 May 2020 14:23:57 EST 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. Full Article JDBCBNDL+SAS/ACCESS+Interface+to+JDBC
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 By feedproxy.google.com Published On :: Fri, 1 May 2020 13:17:00 EST A DATA step and PROC SQL can round numeric values while creating and loading data into a new Databricks table via JDBC. Full Article BASE+Base+SAS
o Problem Notes for SAS®9 - 65886: Trying to bulk load data into a Google BigQuery database might result in an error By feedproxy.google.com Published On :: Fri, 1 May 2020 10:00:17 EST 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 Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
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 By feedproxy.google.com Published On :: Thu, 30 Apr 2020 13:52:24 EST 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 Full Article ORACLE+SAS/ACCESS+Interface+to+Oracle
o Problem Notes for SAS®9 - 65909: SAS Visual Analytics Designer 7.5 responds slowly when you edit large or complex reports By feedproxy.google.com Published On :: Thu, 30 Apr 2020 13:26:35 EST 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. Full Article VISANLYTBNDL+SAS+Visual+Analytics
o Problem Notes for SAS®9 - 64980: The PRINT procedure contains a buffer-overrun vulnerability By feedproxy.google.com Published On :: Thu, 30 Apr 2020 10:19:20 EST Severity: Medium Description: PROC PRINT might fail with a buffer overrun when you submit it in conjunction with certain malformed SAS statements. Full Article BASE+Base+SAS
o Problem Notes for SAS®9 - 64550: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter By feedproxy.google.com Published On :: Thu, 30 Apr 2020 10:18:27 EST Severity: Medium Description: SAS Enterprise Case Management contains a cross-site scripting vulnerability in the CASE_ID parameter. Potential Impact: Full Article CASEMGMTOFR+SAS+Enterprise+Case+Manageme
o Problem Notes for SAS®9 - 65893: Custom sorts are sorted incorrectly when they are used in a hierarchy in SAS Visual Analytics Designer By feedproxy.google.com Published On :: Wed, 29 Apr 2020 12:29:05 EST 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: Full Article VISANLYTBNDL+SAS+Visual+Analytics
o Problem Notes for SAS®9 - 65844: STRESS task fails with "Fatal error in PMPI_Bcast: Other MPI error, error stack: PMPI_Bcast(1478)" By feedproxy.google.com Published On :: Tue, 28 Apr 2020 13:35:57 EST 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: Full Article HPRISKOFR+SAS+High-Performance+Risk
o Problem Notes for SAS®9 - 65835: A series of PROC SQL queries might not generate a distinct set of rows By feedproxy.google.com Published On :: Tue, 28 Apr 2020 12:39:06 EST 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. Full Article BASE+Base+SAS
o Problem Notes for SAS®9 - 65597: An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results By feedproxy.google.com Published On :: Tue, 28 Apr 2020 12:37:41 EST 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 Full Article BASE+Base+SAS
o Problem Notes for SAS®9 - 65572: The length of a string variable might be longer than specified with the MAX_CHAR_LEN= option By feedproxy.google.com Published On :: Tue, 28 Apr 2020 08:30:03 EST 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 Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
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 By feedproxy.google.com Published On :: Mon, 27 Apr 2020 16:10:54 EST 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: Full Article RGPBNDL+SAS+Risk+Governance+Framework
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 By feedproxy.google.com Published On :: Mon, 27 Apr 2020 13:37:52 EST 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 Full Article BRLSTBNDL+SAS+Business+Rules+Manager
o Problem Notes for SAS®9 - 65869: SAS Visual Data Builder does not enable you to schedule with multiple time-event triggers By feedproxy.google.com Published On :: Fri, 24 Apr 2020 12:23:04 EST 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 Full Article VISANLYTBNDL+SAS+Visual+Analytics
o Problem Notes for SAS®9 - 65868: Saving a report distribution in SAS Visual Analytics Designer fails with "The name is invalid" By feedproxy.google.com Published On :: Fri, 24 Apr 2020 12:03:57 EST 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}" /> Full Article VISANLYTBNDL+SAS+Visual+Analytics
o Around the Horn: Pham, Choi aim to boost Rays By mlb.mlb.com Published On :: Wed, 6 Feb 2019 10:51:07 EDT 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. Full Article
o Here's your guide to Rays Spring Training By mlb.mlb.com Published On :: Wed, 6 Feb 2019 14:04:04 EDT 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. Full Article
o Inbox: How will potential new rule affect Rays? By mlb.mlb.com Published On :: Thu, 7 Feb 2019 11:50:31 EDT Rays beat reporter Juan Toribio answers fans' questions. Full Article
o Rays' 2019 mantra: Prepare to win from within By mlb.mlb.com Published On :: Fri, 8 Feb 2019 16:05:02 EDT 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. Full Article
o Bulked-up Duffy looks to sustain at plate in '19 By mlb.mlb.com Published On :: Sat, 9 Feb 2019 17:43:24 EDT 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. Full Article
o Predicting Rays' Opening Day roster By mlb.mlb.com Published On :: Sun, 10 Feb 2019 13:19:32 EDT Here's an early look at how the Rays' 25-man roster could shape up on Opening Day. Full Article
o Uniform patch to mark 150 years of pro baseball By mlb.mlb.com Published On :: Tue, 12 Feb 2019 10:09:05 EDT 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. Full Article
o 30 low-key acquisitions who could pay off big By mlb.mlb.com Published On :: Tue, 12 Feb 2019 13:57:13 EDT 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. Full Article
o Rays two-way prospect McKay to DH only in '19 By mlb.mlb.com Published On :: Mon, 11 Feb 2019 11:45:51 EDT 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. Full Article
o Morton believes Rays can make postseason By mlb.mlb.com Published On :: Tue, 12 Feb 2019 16:01:50 EDT 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. Full Article
o A little rain can't keep eager Rays from field By mlb.mlb.com Published On :: Wed, 13 Feb 2019 15:17:29 EDT 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. Full Article
o Snell not feeling pressure in '19 after Cy win By mlb.mlb.com Published On :: Wed, 13 Feb 2019 11:52:53 EDT After winning the 2018 American League Cy Young Award, Blake Snell said he doesn't feel "any pressure" in '19. Full Article
o Spring brings vet leaders for blossoming Rays By mlb.mlb.com Published On :: Wed, 13 Feb 2019 13:12:50 EDT 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. Full Article
o Prospects who should vie for a roster spot By mlb.mlb.com Published On :: Thu, 14 Feb 2019 19:36:11 EDT 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. Full Article
o Pagan working to develop off-speed pitches By mlb.mlb.com Published On :: Thu, 14 Feb 2019 16:43:16 EDT 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. Full Article
o Prospect Poche making strong first impression By mlb.mlb.com Published On :: Thu, 14 Feb 2019 12:51:58 EDT 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. Full Article
o Faria enters camp fighting for bullpen spot By mlb.mlb.com Published On :: Fri, 15 Feb 2019 13:24:43 EDT After a disappointing 2018 season, Jake Faria is looking to show that last season isn't reflective of the type of pitcher he is. Full Article
o Glasnow working to quicken delivery By mlb.mlb.com Published On :: Sat, 16 Feb 2019 15:35:57 EDT Tyler Glasnow is hoping to build off a positive 2018, but his delivery is going to look a little different this season. Full Article
o Rays' Top 30 Prospects list By m.mlb.com Published On :: Fri, 17 Feb 2017 21:03:54 EDT 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. Full Article
o Kiermaier eyeing 'huge rebound year' in 2019 By mlb.mlb.com Published On :: Sat, 16 Feb 2019 11:43:28 EDT 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. Full Article
o Reasons for optimism for each MLB club By mlb.mlb.com Published On :: Sun, 17 Feb 2019 21:02:04 EDT 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. Full Article
o The Rays' Spring Training battle to watch By mlb.mlb.com Published On :: Mon, 18 Feb 2019 18:20:16 EDT 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. Full Article
o Here are 10 Rays players to watch this spring By mlb.mlb.com Published On :: Sun, 17 Feb 2019 13:46:36 EDT 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. Full Article
o Diaz aims to turn heads, cement everyday role By mlb.mlb.com Published On :: Mon, 18 Feb 2019 19:36:23 EDT 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. Full Article
o Cash reminder: Stay focused on the now By mlb.mlb.com Published On :: Mon, 18 Feb 2019 19:40:59 EDT All 66 players on the Rays' Spring Training roster took the field Monday as Tampa Bay went through its first full-squad workout. Full Article