About JBailey

JBailey · ‎08-28-2020

Hi @knn1888 The "Code Appendage" message most often means that the SAS/ACCESS engine was not installed. See if sasiotra.dll and sasiotpt.dll are in a directory similar to this one: C:\Program Files\SASHome\SASFoundation\9.4\access\sasexe Best wishes, Jeff

JBailey · ‎05-28-2020

Hi @gyambqt Just a guess. The ORDER BY clause sorts on stg.value and stg.date. These values are the same in your output. So, the sort is coming into the PARTITION clause in a different order but is still correct. Greenplum is a highly parallel database. Nodes could be producing intermediate result sets at different times. Thus, producing a random assignment of the tmp_row value. Best wishes, @JBailey

JBailey · ‎04-17-2020

Thank you, @dnew. I appreciate it. Best wishes, Jeff

JBailey · ‎04-06-2020

Hi @ChrisNZ, What a great question. It is best to have questions in their own topic, So, create a new post and include my name (@JBailey) because the site will ping me. I can answer the question, quickly. Best wishes, Jeff

JBailey · ‎04-02-2020

Thanks, Chris. That means a lot. I appreciate it.

JBailey · ‎04-01-2020

Hi @DavidPhillips2 SAS generates SQL and passes it to Oracle. The Oracle Optimizer determines whether, or not, it uses an index. SAS does not directly use Oracle indexes. You can help the Optimizer choose use indexes by ensuring that catalog statistics are current, and passing Oracle Hints. Years ago, Tatyana Petrova and I wrote an SGF paper on database performance tuning. You may find it useful. The SQL Tuning Checklist: Making Slow Queries a Thing of the Past The paper discusses most of what you need to know to use indexes. I think we used Teradata for the examples, but Oracle will be similar. I will warn you; Oracle EXPLAIN PLANs are more difficult to use. Best wishes, Jeff

JBailey · ‎02-18-2020

Hi @HafizhNugraha To be entirely sure we would need to see how the SQL Server table is defined, but I feel certain that the data you are putting into SQL Server is losing precision. This is why the numbers don't add up. @Patrick provides great advice in his response. I would suggest coding a simple example with a few observations. Write them to a test table (created using the same numeric data type defined in your target table). You will be able to easily see what is happening. Best wishes, Jeff

JBailey · ‎02-17-2020

Hi @HafizhNugraha This is likely due to the data type chosen for the database table. Do you know the SQL Server data type for the column in question? Small code examples would be helpful, too. Best wishes, Jeff

JBailey · ‎02-05-2020

Hi @SAShole If you are running SAS via a workspace server, the "userid" running the job may not have permissions to the directory specified in the LIBNAME statement. Best wishes, Jeff

JBailey · ‎01-31-2020

Hi @Kal_ETL Interesting question. I think you may want to contact SAS Tech Support and discuss this with them. That's probably the quickest path to resolution. Best wishes, Jeff

JBailey · ‎01-28-2020

Hi @radha009 SQL1013N and SQLSTATE=42705 means that the database, in this case DBPROD may not have been cataloged on the DB2 client. You can read about it, here. https://www.ibm.com/support/pages/sql1013n-db2-connect If you have the DB2 CLI installed on the client you can invoke it and issue the following command: db2 list db directory If DBPROD isn't listed, it will need to be cataloged. This Stackoverflow thread may help you: https://stackoverflow.com/questions/19303061/db2-database-directory-shows-db-that-does-not-exist If this is all gibberish, you may need to contact your DBA and have them configure the client. Best wishes, Jeff

JBailey · ‎01-24-2020

Hi @eirigoyen You have two options available: DSN-less ODBC connections - you can read about it here. This is the approach that I used in the post you referenced. The CONOPTS= option. The trick is to look at the documentation for the ODBC driver and find the supported options. These options can be passed via either of these options. The following code uses a DSN-less connection to connect to Athena. The information contained in the COMPLETE= option overrides the odbc.ini information. libname athena odbc complete="DRIVER={Simba Athena ODBC Driver}; AwsRegion=us-east-1; S3OutputLocation=s3://bogus-athena-results/; AuthenticationType=IAM Profile; AwsProfile=617292732428-jbsandbox; UseProxy=1; ProxyScheme=HTTP; ProxyHost=111.111.111.111; ProxyPort=80; ProxyUID=ProxyUserID; ProxyPWD=ProxyPassword;" schema=somedb; Here is an example of conopts= (SAS/ACCESS Interface to Impala). The example shows how to pass the ODBC driver options to the driver. Like the DNS-less connection, CONOPTS= overrides the information in the odbc.ini file. libname impdd impala server='quickstart.cloudera' driver_vendor=datadirect conopts="AuthenticationMethod=0;uid='Bert';pw='Ernie'"; Check the documentation for the ODBC driver; there may be a way to use environment variables for the security stuff. If this doesn't help you, let me know and I will try to create an Athena example. Best wishes, Jeff

JBailey · ‎01-22-2020

Hi @HULK, I think you should go straight to SAS Tech Support with this one because the behavior is absolutely not expected. They will want to know if control eventually returns to EG. Best wishes, Jeff

JBailey · ‎01-21-2020

Hi @BigMac , You are using OS file locations and names where you should use LIBNAME.SASDataSetName. Your tgeg LIBNAME statement doesn't work because of a problem in the directory structure you specified. Include it "as SAS code". (little running man icon in the edit dialog so we can see it). It is likely that you are pointing to a directory that doesn't exist or you have an invalid character in the command. I don't think you are pointing to a directory that contains SAS data sets. You don't need to import a *.sas7bdat file; you can point a LIBNAME statement at it the directory and read the file. Ditto the DATA step problem. You should play around with SASHELP.cars. SASHELP is an autoassigned SAS Library. You should be able to run the following code, successfully. data work.cars; set sashelp.cars; run; Best wishes, Jeff

JBailey · ‎01-20-2020

Hi @LinusH, It depends on the STAGE. Table and User Stages are always present in Snowflake. Internal Named Stages must be created by the DBA, or someone with proper privileges. Configuring S3 as a Stage requires AWS configuration. It is a very interesting topic; I am beginning to write this section of the paper today. <things_say_every_time_I_write_an_SGF_paper>I swear this is the last SGF paper I will ever write.</things_say_every_time_I_write_an_SGF_paper> Best wishes, Jeff

Online Status	Offline
Date Last Visited	a week ago