topic Proc Print in ODS and Base Reporting

Proc Print

yonib — Tue, 11 May 2010 06:00:47 GMT

Hi,
Im using Proc Print to create a report.

The Output is in text format:

options ps=45 ls=250 nodate nocenter ;
proc printto file="&tmpdir.Patient Summary - &label..txt" new;
run;
proc print data=all_pat noobs ;
var text;
by pat;
where hospno>=3067 and hospno<=3072;
pageby pat;
run;
proc printto;
run;

At the begining of each page im getting the string "txt".
I dont know how to get rid of it...
Any ideas?

Re: Proc Print

sbb — Tue, 11 May 2010 12:50:09 GMT

Suggest you review this item and then re-post your code, which was truncated:

http://support.sas.com/forums/thread.jspa?messageID=27609

And remember to include your macro variable definition. Better to paste your SAS-generated log instead of just the code for a better response from the forum.

Scott Barry
SBBWorks, Inc. Message was edited by: sbb

Re: Proc Print

yonib — Tue, 11 May 2010 17:06:44 GMT

Hi Scott,
Thanks for the reference,
here is my code:
options ps=45 ls=250 nodate nocenter ;
proc printto file="&tmpdir.Patient Summary - &label..txt" new;run;
proc print data=all_pat noobs ;
var text;
by pat;
where hospno>=3067 and hospno=4;
proc print;run;

The macro definitions are not releavent for my question.
My problem is my output generate the string 'text' in each page (for each pat).
Is there a way to get rid of it ?

Thanks in advance

Re: Proc Print

Cynthia_sas — Tue, 11 May 2010 18:24:44 GMT

Hi:
the string 'text' is on PROC PRINT output because it is the variable NAME of the variable TEXT in your VAR statement. Either the variable NAME or the variable LABEL is used by PROC PRINT as a column HEADER. I believe this is what you are seeing from this statement:
[pre]
var text;
[/pre]

There have been previous forums postings on how to suppress column headers. Refer to these postings:
http://support.sas.com/forums/thread.jspa?messageID=10254⠎
http://support.sas.com/forums/thread.jspa?messageID=27852泌

cynthia

Re: Proc Print

yonib — Tue, 11 May 2010 19:50:36 GMT

Hi Cynthia,
Got it, Thanks for your help !