9 In Memoriam: Lina M. Obeid (1957-2019) [Tribute] By feedproxy.google.com Published On :: 2020-04-01T00:05:29-07:00 Full Article
9 Problem Notes for SAS®9 - 65852: The PANEL procedure produces incorrect results for certain models when the NOINT and RANONE options are specified By feedproxy.google.com Published On :: Fri, 8 May 2020 13:34:29 EST The estimation results might be incorrect in PROC PANEL when the RANONE and NOINT options are specified in the MODEL statement. Full Article ETS+SAS/ETS
9 Problem Notes for SAS®9 - 65940: You might receive "ERROR: PI Point not found" when you query a PI tag name that contains a special character such as an ampersand (&) By feedproxy.google.com Published On :: Fri, 8 May 2020 11:20:36 EST When you query a PI tag name or element that contains a special character, such as an ampersand (&), you might receive the following error: Full Article OSISOFT+SAS/ACCESS+Interface+to+the+PI+S
9 Problem Notes for SAS®9 - 65939: "ERROR: Unable to transcode data to/from UCS-2 encoding" occurs when you run an SQL query using SAS/ACCESS Interface to ODBC on SAS 9.4M5 with UTF-8 By feedproxy.google.com Published On :: Fri, 8 May 2020 11:20:02 EST When you run an SQL query using SAS/ACCESS Interface to ODBC under the following conditions, you might receive an error: You run SAS 9.4M5 (TS1M5) or SAS 9.4M6 (TS1M6) i Full Article ODBC+SAS/ACCESS+Interface+to+ODBC
9 Problem Notes for SAS®9 - 65938: Incorrect values might be written to Hadoop for columns defined with the BIGINT data type By feedproxy.google.com Published On :: Fri, 8 May 2020 10:20:46 EST Large numeric values consisting of 16 digits in SAS might be incorrect when written to Hadoop for columns defined with the BIGINT data type. This problem was introduced in SAS 9 Full Article HADOOP+SAS/ACCESS+Interface+to+Hadoop
9 Problem Notes for SAS®9 - 65900: Registering an Oracle table to the metadata might fail and generate an error By feedproxy.google.com Published On :: Fri, 8 May 2020 09:38:11 EST When you register an Oracle table to the metadata, it might fail and generate an error similar to the following: "ERROR: An exception has been encountered...ERROR: Read Access Violation METALIB..." Full Article METADATASRV+SAS+Metadata+Server
9 Problem Notes for SAS®9 - 35066: When a bulk-loading process fails with "SQL*Loader 2026" error, error message appears as a warning in the SAS log By feedproxy.google.com Published On :: Thu, 7 May 2020 17:15:19 EST If a bulk-loading process fails when you use SAS with SAS/ACCESS Interface to Oracle, you will receive the warning: "WARNING: All or some rows were rejected/discarded.: The actual error is "SQL*Loader-2026: The load was aborted because SQL Full Article ORACLE+SAS/ACCESS+Interface+to+Oracle
9 Problem Notes for SAS®9 - 65834: PROC METADATA returns various errors when the input contains certain multi-byte characters By feedproxy.google.com Published On :: Thu, 7 May 2020 17:12:13 EST The METADATA procedure might return an error similar to one of the following: ERROR: Missing root element definition. Full Article BASE+Base+SAS
9 Problem Notes for SAS®9 - 65899: "ERROR: ORACLE disconnect error: ORA-03135" occurs when SAS disconnects from the Oracle database server By feedproxy.google.com Published On :: Thu, 7 May 2020 08:04:08 EST When you run 32-bit SAS on Windows and disconnect from the Oracle database server, you might see the error: "ERROR: ORACLE disconnect error: ORA-03135: connection lost contact." Full Article ORACLE+SAS/ACCESS+Interface+to+Oracle
9 Problem Notes for SAS®9 - 60332: A SAS 9.4 installation in Update mode notifies you about unwritable files in the "SASHome\SASWebApplicationServer" directory By feedproxy.google.com Published On :: Wed, 6 May 2020 14:49:04 EST When you run SAS Deployment Wizard to install or update SAS 9.4 software, the file system is examined. If any files that the wizard needs to delete are found to be locked, they are reported as unwritable f Full Article BASE+Base+SAS
9 Problem Notes for SAS®9 - 65918: SAS Workflow Services fails to respond after a com.sas.workflow.engine.policy.PolicyExecutionException error occurs for a workflow instance By feedproxy.google.com Published On :: Wed, 6 May 2020 13:42:50 EST When the problem occurs, you are unable to perform any workflow actions in a SAS solution that uses SAS Workflow Services. Full Article WEBINFPLTFM+SAS+Web+Infrastructure+Platf
9 Problem Notes for SAS®9 - 65929: A grid-enabled sign-on to SAS 9.4M6 (TS1M6) fails with errors, including "Remote signon Â… canceled" By feedproxy.google.com Published On :: Wed, 6 May 2020 13:02:23 EST A sign-on to a grid-enabled environment fails while it is trying to communicate with the client host. The following errors then appear in the SAS log: < Full Article GRIDMGR+SAS+Grid+Manager
9 Problem Notes for SAS®9 - 64285: The SCD Type 2 Loader transformation in SAS Data Integration Studio generates "ERROR 22-322: Syntax error, expecting one of the following:..." By feedproxy.google.com Published On :: Wed, 6 May 2020 12:38:17 EST If your business key column is a name literal, like " business key "n, a syntax error occurs when that variable name does not follow standard SAS naming conventions. Full Article DATABUILDER+SAS+Data+Integration+Studio
9 Problem Notes for SAS®9 - 64459: A SAS Data Integration Studio job receives an error that states "The name '; index_name '; has the wrong number of qualifiers" By feedproxy.google.com Published On :: Wed, 6 May 2020 12:37:37 EST An error occurs because of an incorrectly generated CREATE INDEX clause in an SQL query that is sent to DB2 when the DB2 schema value is SESSION . The error message says "The name '; index_name '; has the wrong number of qualifie Full Article DATABUILDER+SAS+Data+Integration+Studio
9 Problem Notes for SAS®9 - 65908: The IMPORT procedure contains a stack-corruption vulnerability By feedproxy.google.com Published On :: Wed, 6 May 2020 10:55:40 EST Severity: Medium Description: PROC IMPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances (with use of the DBM Full Article BASE+Base+SAS
9 Problem Notes for SAS®9 - 65906: The EXPORT procedure contains a stack-corruption vulnerability By feedproxy.google.com Published On :: Wed, 6 May 2020 10:55:01 EST Severity: Medium Description: PROC EXPORT contains a stack-corruption vulnerability. Potential Impact: Under certain circumstances, the use of PROC EXP Full Article BASE+Base+SAS
9 Problem Notes for SAS®9 - 65922: Trying to read a Google BigQuery table that contains a variable defined as an array might result in a panic error and SAS shutting down By feedproxy.google.com Published On :: Wed, 6 May 2020 10:30:19 EST Trying to read a Google BigQuery table that contains a variable that is defined as an array of records might result in an error and cause SAS to shut down. This issue occurs when one of the variables contained in Full Article BIGQUERY+SAS/ACCESS+Interface+to+Google+
9 Problem Notes for SAS®9 - 65295: The order of columns is not maintained when you select columns for output in the Business Rules transformation By feedproxy.google.com Published On :: Wed, 6 May 2020 10:01:07 EST In SAS Data Integration Studio, the columns that you select to include in the target table in a Business Rules transformation appear in the Selected columns area in a random order. Th Full Article DATABUILDER+SAS+Data+Integration+Studio
9 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+
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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+
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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+
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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