topic Re: Unable to Print Selct Query in SAS Procedures

Unable to Print Selct Query

K_HARI__PRASAD — Mon, 14 Dec 2015 12:55:40 GMT

Hi,

I tried once to PRINT select query in PROC PRINT, its worked for one time. But after the session turned off, I am unable to PRINT.

Below is the sample query.

PROC PRINT;

PROC SQL;

SELECT a,b,c FROM XYZ;

QUIT;

RUN;

Many thanks in advance.

Re: Unable to Print Selct Query

Jagadishkatam — Mon, 14 Dec 2015 13:03:52 GMT

Just try

PROC SQL;
SELECT a,b,c FROM XYZ;
QUIT;

No proc print required.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Mon, 14 Dec 2015 13:34:46 GMT

I tried, but still the same result. It's not printing.
Thank you.

Re: Unable to Print Selct Query

RW9 — Mon, 14 Dec 2015 13:48:08 GMT

By what do you mean "print" the query? Just putting the select will output the results directly to the output window if running interactive SAS unless you have turned that option off with:

ods noresults;

You can turn it back on with:

ods results;

If you mean you want to keep the data as a file then its a simple two step process:

extract data to a dataset then print the dataset:

proc sql;
  create table WANT as
  select A,
            B,
            C
  from   HAVE;
quit;

ods rtf file="c:\results.rtf";
proc report data=want;
  columns _all_;
run;
ods rtf close;

Its very dependant on what you are doing/want which is not clear from your post.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Mon, 14 Dec 2015 13:51:58 GMT

I don't want to create a file with the select query result. I just want to display the results. Even I am unable to print permanent or work library datasets.

Re: Unable to Print Selct Query

RW9 — Mon, 14 Dec 2015 14:54:35 GMT

And how do you want to display them, via file, output window? Have you tried the ods results? What about ods listing. What software are you using, is is interactive SAS or Batch.

Re: Unable to Print Selct Query

Reeza — Mon, 14 Dec 2015 15:33:10 GMT

Are you using SAS Base installed? If so, it's possible you closed the output window by accident. Go to view and results to see the output window again.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Mon, 14 Dec 2015 16:15:16 GMT

I am using SAS EG. I just tried to print data set (work or permanent lib) /select query. It's not printing 🙂

Re: Unable to Print Selct Query

K_HARI__PRASAD — Mon, 14 Dec 2015 16:17:30 GMT

@RW9 :I want to print the results in output window

Re: Unable to Print Selct Query

Reeza — Mon, 14 Dec 2015 16:23:53 GMT

Post your code and the log.

Re: Unable to Print Selct Query

RW9 — Mon, 14 Dec 2015 16:25:11 GMT

ods listing;
proc sql;
  select * from sashelp.cars;
quit;

Then open the output window (not sure where its located as dont use EG, probably off the menu bar at the top, something like show output window).

Re: Unable to Print Selct Query

K_HARI__PRASAD — Tue, 15 Dec 2015 04:31:47 GMT

Hi Reeza,

My code
---------------------------
data abc;
input e f g;
infile datalines;
datalines;
1 2 3
4 5 6
7 8 9
;
run;

proc print data=abc;
run;

--------------------------------

LOG
*********************************
16 GOPTIONS ACCESSIBLE;
17 data abc;
18 input e f g;
19 infile datalines;
20 datalines;

NOTE: Compression was disabled for data set WORK.ABC because compression overhead would increase the size of the data set.
NOTE: The data set WORK.ABC has 3 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

24 ;

25 run;
26
27 proc print data=abc;
28 run;

NOTE: There were 3 observations read from the data set WORK.ABC.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

29
30 GOPTIONS NOACCESSIBLE;

**************************************************

Re: Unable to Print Selct Query

Reeza — Tue, 15 Dec 2015 04:33:45 GMT

Go to Options and Results tab, ensure that the a Result type is selected. If that doesn't work, you'll need to contact SAS Tech Support.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Tue, 15 Dec 2015 04:45:29 GMT

hI Reeza,

I selected Results as SAS Report, HTML formats. But still the result is not displyed in the out put window.

Thanks for your time.

Re: Unable to Print Selct Query

dkb — Wed, 16 Dec 2015 02:09:37 GMT

After you run the code, does your EG process flow look something like this?

Re: Unable to Print Selct Query

K_HARI__PRASAD — Wed, 16 Dec 2015 05:56:33 GMT

Hi dkb,

No. its not.

Thank you.

Re: Unable to Print Selct Query

dkb — Wed, 16 Dec 2015 07:26:12 GMT

What does it look like then?

The more you tell us about the problem, the better the advice you will get back.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Thu, 17 Dec 2015 05:27:36 GMT

Hi dkb,

Lets take the below scenario.

1. I want to print sashelp.air data set

2. The output window doesnot displaying the PRINT results

I attached the screen shorts of code widnow,procss flow and options I have given in EG.

Thanks for your time.

Re: Unable to Print Selct Query

Reeza — Thu, 17 Dec 2015 15:41:42 GMT

Did you press run? Show a screenshot of the log as well please.

Re: Unable to Print Selct Query

K_HARI__PRASAD — Fri, 18 Dec 2015 10:58:37 GMT

Hi Reeza,

Yes, I clicked on Ran .Please find the attachment for logs.

Thank you.