topic Re: How to read what's sent via proc sql? in SAS Health and Life Sciences

How to read what's sent via proc sql?

deleted_user — Thu, 07 Feb 2008 14:37:43 GMT

There is a way to see on the log what's sent via proc sql? What is the option that I have to put?

For an example, if I run the folloowing,

%let obsn=5;

proc sql;
connect to oracle (user=&user1 pass=&pass1 path=odin);
create table id_data as
select * from connection to oracle
( select *
from id_details
where rownum < &obsn);
disconnect from oracle;
quit;

I want to see the following on the log:

proc sql;
connect to oracle (user=myusername pass=mypassword path=odin);
create table id_data as
select * from connection to oracle
( select *
from id_details
where rownum < 5);
disconnect from oracle;
quit;

Re: How to read what's sent via proc sql?

Doc_Duke — Thu, 07 Feb 2008 15:43:16 GMT

The option you are looking for is called MPRINT.

Re: How to read what's sent via proc sql?

deleted_user — Thu, 07 Feb 2008 16:29:46 GMT

Hi Doc@Duke,

I'm also seeing the following:
MPRINT(MYQUERY): ;
MPRINT(SPEED1): data space.mydata
MPRINT(SPEED1): set
MPRINT(FILENAMES): speed_data_1
MPRINT(SPEED1): speed_data_2;
MPRINT(SPEED1): run;

I only want to see the one that was sent to proc sql. I rem seeing it somewhere...I can't recall the option name.

Thanks for the reply.

-Nilan

Re: How to read what's sent via proc sql?

advoss — Thu, 07 Feb 2008 17:13:00 GMT

try adding the PROC SQL feedback option to your code rather than MPRINT.

like:
proc sql feedback;
/* etc */

or use options symbolgen.

Re: How to read what's sent via proc sql?

deleted_user — Thu, 07 Feb 2008 17:13:19 GMT

more details are available.
They are documented with the SAS/Access products

iirc
option SASDtrace

but be wise and look it up

PeterC