About TylerP8813

TylerP8813 · ‎11-29-2022

Nevermind. I was able to use distinct in the select statement to remove the extra rows and a %SYMDEL step at the end of the macro to clear the macro values.

TylerP8813 · ‎08-16-2022

This appears to be the right solution but I keep getting this error: "ERROR: CLI prepare error: [Cloudera][ImpalaODBC] (350) Max query retry limit exceeded. Retry Limit: 5" Which may be due to some settings or issue with driver, etc. rather than SAS itself.

Reeza · ‎05-29-2019

I'm going to guess when you pass an address it may contain a comma? Can you verify the values within address? It would also help if you could show the log, which will show exactly which lines are causing issues. Set the debugging options below first: options mprint symbolgen; You can also add mlogic but I find that one can really make your log big so try those first.

Online Status	Offline
Date Last Visited	‎12-06-2022 01:37 PM

Re: Multiple Sheet Output ODS Excel with Proc SQL

Re: Multiple Sheet Output ODS Excel with Proc SQL

Re: Multiple Sheet Output ODS Excel with Proc SQL

Multiple Sheet Output ODS Excel with Proc SQL

Re: Accessing Table in Impala where Table Name > 32 Char

Re: Accessing Table in Impala where Table Name > 32 Char

Re: Accessing Table in Impala where Table Name > 32 Char

Re: Accessing Table in Impala where Table Name > 32 Char

Re: Accessing Table in Impala where Table Name > 32 Char

Accessing Table in Impala where Table Name > 32 Char

Re: Generate Reports based on Dynamic listing of tables

Re: Multiple Sheet Output ODS Excel with Proc SQL

Re: Multiple Sheet Output ODS Excel with Proc SQL

Re: Accessing Table in Impala where Table Name > 32 Char

Re: Generate Reports based on Dynamic listing of tables