LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2003, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 20 Nov 2003 14:26:42 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: proc report ?
Comments: To: Richard.J.Wilson@RBC.COM
Content-Type: text/plain; charset=us-ascii

Interesting. When I change the program to this:

===== data test; *length filename $300.;

filename=urlencode('fs00235a/scripts/broker.exe?_program=devl.ho_report3.sas'

|| '&_service=devl&_debug=0&firstrun=YES&firstchoice=Central&format=P' || '&program=D&drilldown=1&where1=where promo_name eq ''Event Apr 03''&by=hh_rm*promo_name'); hh_pres= 'Central'; file log; put filename=; run;

ods pdf file='c:\file2.pdf'; ods listing close;

proc report data=test nowd; column filename hh_pres ; define filename / noprint; define hh_pres / display ; compute hh_pres; call define(_col_, 'URL', filename); endcomp; run;

ods pdf close; ods listing; =====

I get a message in the log saying that filename is assigned a length of 200 by default, so the underlying value stops at the "p".

Adding

length filename $300.;

to the data step results in no message, and mysteriously the URL link in the PDF is no longer set - no messages, but also no link.

So I don't know. Looks like a bug. What does SAS Tech Support say?

-- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA

>>> "Richard Wilson" <Richard.J.Wilson@RBC.COM> 11/20/2003 11:34 AM >>> Substitute this in for the filename variable.

filename=urlencode("fs00235a/scripts/broker.exe?_program=devl.ho_report3.sas &_service=devl&_ debug=0&firstrun=YES&firstchoice=Central&format=P&program=D&drilldown=1&wher e1= where promo_name eq 'Event Apr 03'&by=hh_rm*promo_name" );

You should notice that in the address box of the browser it stops at "p" in the &where1 macro variable. Which is the 200th character. Let me know if this is not happening for you.

Thank you for you help.

-----Original Message----- From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM] Sent: Thursday, November 20, 2003 2:13 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: proc report ?

You're not assigning a value to hh_pres in the compute block, so the length restriction shouldn't make a difference. When I run the code below, I get a message saying that filename is too long, but uncommenting the define for filename makes that go away. Then the PDF file is created, and clicking on the link tries to open a file with the name given.

So I'm not yet sure what your problem is.

-- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA

>>> "Richard Wilson" <Richard.J.Wilson@RBC.COM> 11/20/2003 10:42 AM >>> This is what I am trying to do. But in the documentation the compute block has a max of 200 characters for character variables.

data test; filename='This is a is a really long url to a sas\internet program that has some macro variables and is longer than 200 characters '; hh_pres= 'Central'; run;

ods pdf file='c:\file2.pdf'; proc report data=test nowd; column filename hh_pres ; define filename /noprint; define hh_pres /display ; *define filename / width=50 left; compute hh_pres / char length=200; call define(_col_,"URL",filename); endcomp; run; ods pdf close;

-----Original Message----- From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM] Sent: Thursday, November 20, 2003 1:24 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: proc report ?

Please send to the list an example of what you are trying to do.

-- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA

>>> "Richard Wilson" <Richard.J.Wilson@RBC.COM> 11/20/2003 10:09 AM >>> Is there any way to get around the length limitation (200) for a compute block in proc report?

Richard J. Wilson RBC Centura ____________________________ Tel: 252.454.4964 Fax: 252.977.6362

------------------------------------------------------------ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

============================================================

------------------------------------------------------------ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

============================================================

------------------------------------------------------------This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

============================================================


Back to: Top of message | Previous page | Main SAS-L page