topic Re: SybaseIQ and SAS Enterprise Guide in SAS Procedures

SybaseIQ and SAS Enterprise Guide

ksamm — Sat, 03 Mar 2018 00:27:42 GMT

I have a number of large SybaseIQ SQL scripts (5000+ lines each). The READ statement for each contains a number of parameters. Is there a way to execute the READ through the Proc SQL procedure using the SAS/ACCESS for SybaseIQ interface?

many thanks in advance

Re: SybaseIQ and SAS Enterprise Guide

SASKiwi — Sat, 03 Mar 2018 00:42:29 GMT

Can you post an example of a SybaseIQ READ statement? Normally non-standard SQL can be executed via SAS's PASSTHRU EXECUTE statement.

Re: SybaseIQ and SAS Enterprise Guide

ksamm — Sat, 03 Mar 2018 01:14:51 GMT

Thanks for looking at this !!!

parameters parm1 parm2
read ‘’ {source}
[parm1]
[parm2]
{output}

Re: SybaseIQ and SAS Enterprise Guide

SASKiwi — Sat, 03 Mar 2018 01:59:25 GMT

Here is how you do an EXECUTE statement. All you need to do is put your Sybase code inside the brackets. Does this produce a result set by the way? If so then you may need to take a different approach.

documentation.sas.com/?docsetId=acreldb&docsetTarget=n0pj5uu3i328pmn1fackclh2xnd9.htm&docsetVersion=9.4&locale=en

Re: SybaseIQ and SAS Enterprise Guide

ksamm — Sat, 03 Mar 2018 02:18:09 GMT

Thanks SAS Kiwi,

Yes it produces a very large result set. Also, inserting the code between braces is not practical because as I mentioned, some of these queries are 5000+ lines long.

regards

Re: SybaseIQ and SAS Enterprise Guide

SASKiwi — Sat, 03 Mar 2018 02:26:40 GMT

You could wrap the SQL code into an SQL stored procedure, then call that. You will also need to create a temporary table or view instead of producing a result set and then query the table / view in a following "normal" SQL passthru query.

Re: SybaseIQ and SAS Enterprise Guide

ksamm — Sat, 03 Mar 2018 02:33:27 GMT

Good idea !! This sounds feasible, I'll give it a go on Monday and let you know how it goes. However I think there is still one potential issue which I forgot to mention earlier. Some of the parameters to the SQL script need to bee macro variables.

Re: SybaseIQ and SAS Enterprise Guide

SASKiwi — Sat, 03 Mar 2018 02:39:34 GMT

Shouldn't be a problem. The usual hassle is most databases require parameters to be wrapped in single quotes but this technique gets around that problem:

%str(%')&MyMacroVar%str(%')