Help using Base SAS procedures

SybaseIQ and SAS Enterprise Guide

Reply
New Contributor
Posts: 4

SybaseIQ and SAS Enterprise Guide

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

K

Super User
Posts: 3,927

Re: SybaseIQ and SAS Enterprise Guide

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

New Contributor
Posts: 4

Re: SybaseIQ and SAS Enterprise Guide

Thanks for looking at this !!!

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

Super User
Posts: 3,927

Re: SybaseIQ and SAS Enterprise Guide

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=...

 

 

 

 

New Contributor
Posts: 4

Re: SybaseIQ and SAS Enterprise Guide

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

K

Super User
Posts: 3,927

Re: SybaseIQ and SAS Enterprise Guide

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.

New Contributor
Posts: 4

Re: SybaseIQ and SAS Enterprise Guide

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.  

Super User
Posts: 3,927

Re: SybaseIQ and SAS Enterprise Guide

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(%')
Ask a Question
Discussion stats
  • 7 replies
  • 130 views
  • 1 like
  • 2 in conversation