About Quentin

Quentin · ‎05-29-2012

Hi, I think generation data sets could be helfpul to you (GENMAX= option). See e.g.: http://www.nesug.org/Proceedings/nesug11/cc/cc05.pdf --Q.

Quentin · ‎05-29-2012

If the user has mprint etc turned on, you can turn them off at the begining of your macro, then restore them at then end.

Quentin · ‎05-29-2012

Hi, A few quick thoughts. 1. I would suggest instead of writing to ods document, write straight to a pdf file. That will take any document/replay issues out of the mix. 2. Try writing a simple ods pdf example, and see if you can get the formatting you want. Write it around a sashelp dataset, so that you can post your example code with questions. something like: ods pdf file="d:\junk\mypdf.pdf"; proc report data=sashelp.shoes nowd; define region /group; break after region/ dol summarize; run; ods pdf close; 3. I think the OL DOL options only apply to the list (i.e. standard text) output. To get them into your pdf, you are correct that you need to use ODS styles (either a template or in-line formatting.) 4. A great reference for ODS is "Output Delivery System: The basics and behond" by Haworth, Zender & Burlew. There are also lots of user group papers (lexjansen.com). HTH --Q.

Quentin · ‎05-29-2012

Hi, I've used EG 4,3 over VPN and found it to be slow, but not ridiculously slow as you describe. I would encourage you tall call SAS tech suppport yourself and see what they tell you. In the past when I've worked places where IT didn't care about supporting SAS, I found it very helpful to call SAS tech support myself, than call back the IT help desk and tell them what I was told. Cuz too often someone in IT was happy to say "SAS can't be set up that way," or "version x of that hasn't been released yet", but the folks at tech support are always wonderful, and had no problem saying "You can tell them that we said it is available, and if they want to request the installation media all they have to do is.... " Regards, -Q.

Quentin · ‎05-25-2012

I share your curiousity (I've worked in several SAS shops, but this is my first time working in BI). I guess I meant I personally do not have control overt the databases that my stored processes consume. The databases themselves are maintained by the DBAs. So I could "trust" the databases (that all the integrity constraints are defined, etc etc). And then if bad data snuck in and somebody noticed my stored process returned an incorrect report, I would claim "Garbage in, Garbage out, blame the DBA." But over the years, I've learned NOT to trust that data are clean (even when I do manage the database : ) And if a report generated by my stored procedure is incorrect, I don't thin folks will be happy with finger-pointing. So if the SAS log can tell me that missing values were created for some records because values were missing/invalid (or a 100 other messages), I don't want to return a misleading report to the user.

Quentin · ‎05-25-2012

Jay, As described in my first post, I'm trying to set up a process where when a user submits a stored process to generate a report, the stored process will scan the SAS log for any problematic messages (errors, warnings, or bad notes), and if there are bad messages, will return those to the user, instead of the report. So it's roughly: 1. Run a report and write the report to a file (html/pdf/rtf/SASREPORT), but do NOT display the results to the user. 2. Scan the log from running the report. 3. If the log is clean, I will want to stream the report to user. If the log has errors, I will display an error message to the user. [Another option I played with was using ods document as a tool to hold the report and later replay it.] I'm new to working on stored processes/application development for use by non-programmers. As a SAS programmer, I always run a %logcheck on my log before trusting (even looking at) results. So I feel like as a developer, I should give users the same level of error-detection. Of course ideally code will trap errors before they are encountered. But especially in the BI world, where the person who programs a stored procedure may not have any control over the live source databases that are inputs to the procedure, it seems worth checking the log, rather than assuming that if SAS returned a result, everything must have run fine. But I'd be happy to hear thoughts from you or others on this sort of approach. I've tried to start threads here and on SAS-L, with little interest generated. So maybe I'm off-base. But in my gut, I feel like it would be close to negligence to release an application that used SAS but completely ignored the SAS log.... --Q.

Quentin · ‎05-24-2012

I think I've got streaming of a file back to _webout working. Instead of using %filesrv for the pdf, I found a tip on serving a binary file: http://support.sas.com/kb/6/588.html . Below is my current code for streaming a file sitting on the server (html, rtf , pdf): data _null_; file _webout; infile myhtml; input ; put _infile_; run; data _null_; file _webout; infile myrtf; if _n_ = 1 then do; rc = stpsrv_header('Content-type','application/msword'); rc = stpsrv_header('Content-disposition',"attachment; filename=SampReplay_rtf.doc"); end; input ; put _infile_; run; data _null_; file _webout recfm=s; infile mypdf recfm=n; if _n_ = 1 then do; rc = stpsrv_header('Content-type','application/pdf'); rc = stpsrv_header('Content-disposition',"attachment; filename=SampReplay_pdf.pdf"); end; input c $char1.; put c $char1. @@; run;

Quentin · ‎05-24-2012

Hi, Jay, Thanks for replying. I actually haven't tried this yet, so can't tell you what errors I have hit (may be posting more this afternoon...). I assumed this method might not work with a PDF file, since it is not a text file. I would expect RTF and SASREPORT (xml) to be easier. Looking around a bit, looks like maybe I need to use %filesrv? http://support.sas.com/rnd/web/intrnet/filesrv/filesrv.html Have you seen any (simple-ish) examples of writing having one requeset that writes a rtf/pdf to somewhere on the server, and then streams that file back to the user? Thnaks, --Q.

Quentin · ‎05-23-2012

Perhaps an odd question, but... How can I have a stored process open a static html/pdf/rtf/SASREPORT file that is sitting on the server? By "open" I mean display the results if it is html or SASREPORT, prompt the user to open or download if it is pdf/rtf. Process will be called from SPWA and/or WRA, on the stored process server. Background is that I am imaging a stored process where I will: 1. Run a report and write the report to a file (html/pdf/rtf/SASREPORT), but NOT display the results to the user. 2. Scan the log from running the report. 3. If the log is clean, I will want to display the report. If the log has errors, I will display an error message. My first thought was to use ODS document to generate the report (without displaying in). Then I can conditionally REPLAY the document inside of %STPBEGIN / %STPEND to display the results. That works okay, but I lose some minor formatting which isn't captured in the document (e.g. page break info). So I was thinking I could just use good old ods html/pdf/rtf to write a file to a temp location on the server, and then conditionally display it. But once the file is wrtten, I'm not sure how to display it? I think I basically want to push the file back to _webout (with the appropriate header indicating it's an attachement when it is rtf or pdf or SASREPORT). Maybe for html it's as simple as something like: data _null_; file _webout; infile "file"; input; put _infile_; run; ? But not sure how it would work for pdf/rtf, and Henderson's book is at the office.... Thanks,, --Q.

Quentin · ‎05-23-2012

Thanks Shiva, Yes, was hoping to do exactly that: Not tested,but how about creating an ODBC server/library and registering the access data in SAS MC. AFAIK (I'm new to this), since the SAS server is a linux box and the access file is sitting on a windows server, I can't create an ODBC connection pointing to the access file. That is, I don't think the SAS server can see anything sitting on our windows file servers. Believable? --Q.

Quentin · ‎05-23-2012

Thanks. Looks like I can't avoid uploading the file to the server. Bummer. Appreciate your upload code. Will play with this approach (or just write a job to upload their data into a SQL server database that the SAS server can see).

Quentin · ‎05-21-2012

Thanks Shiva, Good to know it's not an inherent limitation. Maybe I can get the server admin to check the server logs, and see if they show anything going on... --Q.

Quentin · ‎05-21-2012

Hi All, I have a stored process that creates a lot of graphs. When I run it from Web Report Studio, it looks like only the first 15 images are incorporated into the SASREPORT file. For the rest of the images, I see the empty_default_image.gif: If I export the report from WRS and look in the zip file, indeed it only has 15 images in it. The SAS log claims that all of the images were created successfully. When I run the procedure from EG, the SASREPORT file has all plots. So is this some sort of time-out that is happening when the procedure is called from WRS, or some other limitation? I can recreate it, with just: %macro mkplots(n=50); %do i=1 %to &n; title "Plot #&i"; proc gplot data=sashelp.class; plot height*weight; run; quit; %end; %mend; %mkplots() Thanks, --Q.

Quentin · ‎05-21-2012

Thanks Cynthia, Looks like I can get most of the way by testing &_URL and &_MSOFFICECLIENT. --Q.

Quentin · ‎05-18-2012

Thanks very much! I made sas.com a "trusted site" (tools->options), and that seems to have done the trick. When I paste I still get the confirmation dialog box you get, but that is much better than nothing! Thanks, -Q.

Online Status	Offline
Date Last Visited	yesterday

Re: Check Out The Winners - 2024 SAS Customer Recognition Awards

Re: Change format of date in macro variable

Re: How do I subset a library so that it no longer contains views and ...

Re: CAS is Fast

Re: CAS is Fast

Re: CAS is Fast

Re: How to iteratively run macros while toggling on/off multiple macro...

Re: How to iteratively run macros while toggling on/off multiple macro...

Re: Methods to hide rows in PROC TABULATE

Methods to hide rows in PROC TABULATE

Re: How do I compare two libraries?

Re: Severe penalty for using MFILE?

Re: How to merge a smaller dataset into a larger dataset with repetiti...

Re: Severe penalty for using MFILE?

Re: Severe penalty for using MFILE?

Re: Check Out The Winners - 2024 SAS Customer Recognition Awards

Re: Change format of date in macro variable

Re: How to translate values?

Re: Severe penalty for using MFILE?

Re: Processing Time on Macro Variables Resolved within a Macro Functio...

Re: how to set options to create a dataset with same name but not repl...

Re: How to specify the SAS options to run macro without show the conte...

Re: Struggling with Styles

Re: EG 4.3 over VPN "not recommended"?

Re: How to display a pdf/html/rtf file?

Re: How to display a pdf/html/rtf file?

Re: How to display a pdf/html/rtf file?

Re: How to display a pdf/html/rtf file?

How to display a pdf/html/rtf file?

Re: Upload access file to Stored Process?

Re: Upload access file to Stored Process?

Re: Web report studio time-out (?) creates missing images?

Web report studio time-out (?) creates missing images?

Re: How can a stored process know which application invoked it?

Re: How to paste text into a post?

SAS Inner Circle Panel

SUGA

SAS Analytics Explorers

SAS Explore

SAS User Groups