SAS Support Communities

Hi,   I'm running SAS 9.4 (M3) on a Windows 2016 Server. When accessing a DB2 Database (DB2 v11.1.4.5) on AIX 7.2 via SAS/ACCESS Interface to DB2, I get the following warning message:   WARNING: During read: [IBM][CLI Driver] CLI0182W Fractional truncation.SQLSTATE=01S07 : [IBM][CLI Driver] CLI0182W Fractional truncation. (The message is repeated some more times. )   Occasionally, an additional error message occurs:   ERROR: An error occurred when translating from one type of character encoding to another.   I guess, the messages have something to do with encoding issues. While our database uses UTF-8, SAS uses WLATIN1. But changing the encoding within SAS is not an option. A "special feature": The same code sometimes results in warnings or error message, and sometimes it does not.   I found http://support.sas.com/kb/64/478.html, but this does not work within our environment.   Has anybody an idea how to solve this issue? ... View more

Hi,    I use SAS 9.4 TS Level 1M3. Does anyone know a solution for reading Parquet files (https://en.wikipedia.org/wiki/Apache_Parquet ) by using SAS without having SAS/ACCESS Interface to Hadoop?    Thanks a lot, Sven ... View more

Hi,    I came across with a statement like the following:   proc sql; create table tmp01 as select col1 , col2 , max(col3, col4) as MaxVar from ... ; quit; So, MAX is used without GROUP BY seemingly as a (row wise) scalar function like within a DATA STEP. Being familiar with "native SQL", I would have expected something like CASE WHEN ELSE END or GREATEST instead of MAX, but the results seem to be the same. Hence, my question is: Can I really use MAX within PROC SQL as it is done within the example? (Correct results also might by coincidence.)   Thanks for your help, Sven ... View more

Hi,   I stored some data using SPDE in a Windows environment. Unfortunately, a colleague moved and renamed folders. Now, I can see the SPDE files using the Windows Explorer, but SAS does not find them. I already found the following statement in the SPDE Reference:   'CAUTION: Do not rename, copy, or move an SPD Engine data set or its component files using operating system commands.'   Anyway, I ask if there is a possibility to restore my data. In my opinion, it is necessary to update the SPDE metadata, but I don't know how to do so. Any ideas?   Many thanks, Sven     ... View more

Hi all,   I use SAS 9.4 TS Level 1M3, W32_ES08R2 Windows NT Server-Version, on a x64-based MS Windows Server 2008 R2 Enterprise operating system. When using PROC FedSQL with multiple joins and sub-queries, I sometimes get stochastic results. So far, I think to have figured out the source in the order of table processing (-> execution plan using PROC FedSQL _method; ). But: A procedure delivering results depending on the execution plan is not very useful. Has anyone made comparable experiences?   Best, Sven ... View more