About ShaneRosanbalm

ShaneRosanbalm · ‎09-19-2018

@RW9, thanks for the reply. >> You need to show the rest of the code, titles and such like. Complete code was included in the attached ZIP file. I thought it would clutter things if I included the full code in the body. I'll just post full code in the body next time. I tried NOGTITLE but got the same thing as before. SOLUTION: Reducing the HEIGHT from 10.5 to 10.0 seemed to work (with or without NOGTITLE).

ShaneRosanbalm · ‎09-19-2018

I am using ODS PDF to capture SGPANEL output. There are too many rows to fit on a single page (15), so I am using ROWS=5 to split the output across 3 pages. ods pdf file="&path/changes.pdf"; proc sgpanel data=sc00; panelby function monthyear / columns=3 rows=5 novarname; series y=ratiofirst x=snapshotdt; series y=ratioprev x=snapshotdt; rowaxis display=(nolabel) refticks; colaxis display=(nolabel) refticks; run; ods pdf close; The first 2 pages of output are fine, but the 3rd page contains only a title. Then there is a 4th page that has a double-title (one in the image, one above the image). This is very mysterious! Any help is greatly appreciated. Complete code and output are attached. I am using 9.4m4.

ShaneRosanbalm · ‎09-14-2018

@Ksharp, thanks for the suggesting, but removing the range attribute map would not produce the type of plot I need. The default color response behavior does not provide the blocks of constant color that are needed in this application.

ShaneRosanbalm · ‎09-14-2018

@ballardw, thanks for the offer! Attached is a complete program and CSV data to create the above graphic. You need only change the value of &PATH at the top. Have fun playing!

ShaneRosanbalm · ‎09-13-2018

I am producing a HEATMAP in SGPLOT 9.4m4. I am trying to use the INTEGER option in the GRADLEGEND statement so that my color response legend only shows integer tick values (-2, -1, 0, 1, 2). Instead of getting integer tick values I am getting tick values that align with the MIN/MAX values coming out of my RATTRMAP dataset. Is this expected behavior? I don't see anything in the documentation to suggest that RATTRMAP overrides INTEGER. But maybe I haven't looked closely enough. proc sgplot data=alerts rattrmap=rdbl5std ; heatmap y=functionn x=monthyear / colorresponse=loadstd rattrid=rdbl5std discretex discretey outline outlineattrs=(color=lightgray) ; yaxis reverse display=(nolabel); xaxis display=(nolabel); gradlegend / position=bottom INTEGER; run;

ShaneRosanbalm · ‎03-06-2017

@FriedEgg, thanks for the link. To benefit anybody who stumbles upon this post in the future, I'll add just a few clarifying details. The most important link on the page you mentioned above (http://www.sascommunity.org/wiki/TeX_and_LaTeX) is this one: http://ctan.math.washington.edu/tex-archive/macros/latex/contrib/conferences/sugconf/ The README explains that sugconf.cls is what allows sugconf-example.tex to generate sugconf-example.pdf.

ShaneRosanbalm · ‎03-03-2017

I would like to write a SUG paper (PharmaSUG, SESUG) using StatRep. The only problem I'm having is that the default TEX/StatRep cosmetics look nothing like the conference templates (different font, margins, formatting, etc.). I could spend the better part of a day searching the internet one formatting option at a time. But I'm hopeful that someone out there has an example TEX file that they can share with the customizations needed for a SUG paper.

ShaneRosanbalm · ‎03-02-2017

> this option is undocumented No wonder I couldn't find it! Thanks for the explanation. This confirms my suspicion that I can simply ignore (or even delete) this option when capturing GTL code produced by the TMPLOUT option of SGPLOT.

ShaneRosanbalm · ‎03-01-2017

When using the TMPLOUT= option in SGPLOT, the resulting code has COLLATION=BINARY on the BEGINGRAPH statement. define statgraph sgplot; begingraph / collation=binary datacolors=(CXFF0000 CX008000 CXB26306); ... I cannot find the option COLLATION in the documentation. Does anybody out there know what it does?

ShaneRosanbalm · ‎02-27-2017

Using STORE and SECURE appears to be the only way to keep the log 100% clear of any output between the macro call (%test) and the desired result (%put). Thanks to @Reeza and @LaurieF for their suggestions.

ShaneRosanbalm · ‎02-27-2017

@LaurieFIf mprint is turned on when the %test macro is called, there are a couple of lines generated in the log prior to the %PUT. 220 %test; MPRINT(TEST): options nonotes; MPRINT(TEST): options nomprint; MPRINT(TEST): ; Max Age -> 16

ShaneRosanbalm · ‎02-24-2017

Reeza, Thanks for the suggestion, but I don't think that works. I don't want anything in my log between the %RESULT call and the %PUT of the results. I think using PROC OPTIONS would give me the same problem as OPTIONS NOMPRINT (namely, the PROC statement would show up in the log). Similarly with OPTIONS NONOTES; if I put this in the macro, I will see OPTIONS NONOTES in my log before I see the %PUT results. My goal is to get MPRINT (and NOTES) turned off without any evidence of a statement having been executed. Perhaps I ask the impossible. Though I hope not. Thanks for taking time to make the suggestion.

ShaneRosanbalm · ‎02-24-2017

Is there a way to set NOMPRINT from within a macro without having the OPTIONS statement show up in the log? The macro in question (let's call it %RESULT) will use DATA, PROC, and macro steps to derive the value of a macro variable. At the very end the macro will report the result to the log with a %PUT statement. Ideally the macro would add nothing to the log prior to the %PUT statement at the end. Is this possible? *--- macro in concept ---; %macro result(data=); DATA... PROC... %if... %put &=result; %mend result; %result(data=cars) *--- desired log lines ---; %result(data=cars) RESULT=428 Note: this is a utility macro, so I will have no control over whether MPRINT is on/off when the macro is called.

ShaneRosanbalm · ‎01-24-2017

PROC STDIZE does tidy things up a bit. Thanks for the suggestion. That said, I will probably poke around a bit and see if I can't find a way to trick SGPLOT (or SGPANEL or GTL) into producing a slightly cleaner looking plot.

ShaneRosanbalm · ‎01-23-2017

I am hoping to create something similar to the Parallel Coordinates Plot from the Data Viz Catalogue (http://www.datavizcatalogue.com/methods/parallel_coordinates.html). The best solution I've found so far is from Prashant Hebbar's SGF 2012 paper (https://support.sas.com/resources/papers/proceedings12/267-2012.pdf) in which he converts each y variable to a percent and then uses a combination of vector, refline, and scatter statements to draw the multiple axes over the top of the series plot. While it works, this approach seems a little bit tedious. Is anybody aware of a more straightforward solution? Or, is this perhaps as simple as it gets?

Online Status	Offline
Date Last Visited	‎08-04-2022 03:15 PM

Re: SGPANEL Causing Blank Page in ODS PDF

SGPANEL Causing Blank Page in ODS PDF

Re: GRADLEGEND option INTEGER not being honored

Re: GRADLEGEND option INTEGER not being honored

GRADLEGEND option INTEGER not being honored

Re: In Search of Example TEX File for StatRep-based SUG Paper

In Search of Example TEX File for StatRep-based SUG Paper

Re: GTL BeginGraph Collation=Binary: What does it mean?

GTL BeginGraph Collation=Binary: What does it mean?

Re: How to set NOMPRINT without seeing corresponding OPTIONS statement...

Re: How to create a Parallel Coordinates Plot in SGPLOT (or GTL)?

In Search of Example TEX File for StatRep-based SUG Paper

Re: SGPANEL Causing Blank Page in ODS PDF

SGPANEL Causing Blank Page in ODS PDF

Re: GRADLEGEND option INTEGER not being honored

Re: GRADLEGEND option INTEGER not being honored

GRADLEGEND option INTEGER not being honored

Re: In Search of Example TEX File for StatRep-based SUG Paper

In Search of Example TEX File for StatRep-based SUG Paper

Re: GTL BeginGraph Collation=Binary: What does it mean?

GTL BeginGraph Collation=Binary: What does it mean?

Re: How to set NOMPRINT without seeing corresponding OPTIONS statement...

Re: How to set NOMPRINT without seeing corresponding OPTIONS statement...

Re: How to set NOMPRINT without seeing corresponding OPTIONS statement...

How to set NOMPRINT without seeing corresponding OPTIONS statement in ...

Re: How to create a Parallel Coordinates Plot in SGPLOT (or GTL)?

How to create a Parallel Coordinates Plot in SGPLOT (or GTL)?