About BenConner

BenConner · ‎07-02-2017

T.S. responded; this is a defect. With a cool workaround. 🙂 proc format; value $dumbplan 'Second Test' = 'Second^{style[fontstyle=italic] ^{nbspace 2} Test}'; run; Using the non-breaking space code will take care of it. Is SAS doing 24x7 T.S. now?? Impressive. --Ben

BenConner · ‎07-01-2017

Thanks, Cynthia! Will run it by the TS folks and see what they say. I'll post a final comment here after they track it down. Much appreciated! --Ben

BenConner · ‎06-28-2017

Hi, I'm testing applying formatting to parts of a data line when generating an Excel spreadsheet. The sample code below looks fine going to html but not to Excel--the 2nd test line has the space before Test drop out. Can anyone shed light on why this might be happening? Thanks! --Ben %let path=c:\temp\; proc format; value $dumbplan 'Second Test' = 'Second^{style[fontstyle=italic] Test}'; run; data text; input line $70.; format line $dumbplan.; cards; First Test Second Test Third Test ;;; ods escapechar='^'; ods excel options(sheet_name='Test' sheet_label=' ') file="&path.mytest.xlsx"; proc print data=text; id line; run; ods excel close;

BenConner · ‎06-27-2017

Quite true. I was almost depressed after taking the Dataflux class a few years ago, thinking of the time I wasted coding similar jobs in base SAS over the years. 🙂 Ben

BenConner · ‎06-27-2017

Thanks; I guess I was dreaming. 🙂 --Ben

BenConner · ‎06-27-2017

Is DM Studio part of Base SAS? I saw that but wasn't sure. I don't have it on the server I have access to but that could be they just didn't install it. --Ben

BenConner · ‎06-27-2017

Good morning, I seem to recall reading a while back about some of the Dataflux functionality being made available in Base SAS. I could be dreaming, as I can't find any docs on this. Did any of this happen? Thanks! --Ben

BenConner · ‎05-18-2017

Hi, I analyze log files which historically have been text based; with the increase in hacking attacks, these now contain binary data from other servers. SAS can't read past certain locations and I suspect there is an embedded EOF character in them. I've tried several options on the filename and infile statements to read the 11 lines of the attached sample. Is there something I can use that will read all 11 lines? Example: data test; infile 'c:\smtp.txt'; input; put _infile_; run; only reports 4 lines read. Thanks! --Ben

BenConner · ‎05-18-2017

Hi Robert, Thanks for the ideas; this application has a varying # of zip codes shown in the same size area on a report, so I won't be able to generalize and insert an annotate entry. If I come across anything I will post it here. --Ben

BenConner · ‎05-01-2017

Hi, I'm creating a series of maps with zip code boundaries. The zips are (theoretically) close to each other but I'm finding out that isn't always the case. It would be useful to have a scale indicating how many pixels and/or inches to the mile, much as you find on Google Maps, etc. My first reaction is this isn't possible until we know what it will be printed on, but in my case I've already defined a known width and height in inches on the target document size (8.5x11 inches in this case). Is there a way to generate this? --Ben

BenConner · ‎03-08-2017

Hi Bruno Thanks! So it wasn't an issue with sizing after all. I was leading myself down the wrong path. Sounds like I need to run this by the folks in tech support in case there is something that needs to be fixed. Much appreciated! Ben

BenConner · ‎03-07-2017

Hi Bruno, Thanks for replying. I suspect it is size related but am not sure it is the root cause in this instance. Consider the following test where I used the state map dataset and pulled off the first 15 outlines. I reduced the size of the images to a 2"x2" square and the pdf actually got worse. ? I suspect the layout code is working because when I uncomment the ods html statement that comes out fine. --Ben title; options nodate topmargin=.1in bottommargin=.1in leftmargin=.1in rightmargin=.1in orientation=landscape; ods graphics on / width=2in height=2in; goptions device=actximg hsize=2in vsize=2in;; ods html close; * select an empty pattern (v=e); pattern v=e; proc sql outobs=15; create table states as select distinct statecode from maps.us; run; proc sort data=maps.us out=maps; by statecode; run; proc document name=work.states; delete \states; run; quit; ods document name=work.states (update) dir=(path=\states label='States'); proc gmap map=maps data=states; by statecode; id statecode; choro statecode / nolegend; run; quit; ods document close; ods pdf notoc file="&path.test.pdf"; *ods html; ods layout gridded columns=3 advance=output column_gutter=0; ods region; proc document name=states ; replay \states /levels=all; run; quit; ods layout end; ods pdf close;

BenConner · ‎03-06-2017

Hi, I stored a series of gmap outputs to a document store and am trying to replay them to one or more sheets in a PDF file. Each image should fit in a 2.75x3.5" rectangle and I wanted them 3 across (in landscape mode). The code I'm using is: options mprint nodate nonumber center orientation=landscape; options topmargin=.25IN bottommargin=.25IN leftmargin=.25IN rightmargin=.25IN ; ods graphics on / width=3.5in height=2.75in; ods pdf notoc file="&path.test.pdf"; ods layout gridded columns=3 advance=table; ods region width=3.5in height=2.6in; proc document name=in.ActV; replay \zipmap / levels=all; run; quit; ods layout end; ods pdf close; Directing this to HTML, I get what I would expect: 3 columns and however many rows the data populates. Going to PDF, the 1st column disappears and only 1 or two graphs show up per page. The image that does show up is the 2nd column shifted to the 3rd column's position. I'm not sure what's going on, or how to tell Proc document to drop an image in each of the row/column positions. None of the arguments in the advance= ODS option seems to fit. I attached the sample pdf file to illustrate the issue. ? Thanks! --Ben

BenConner · ‎03-02-2017

Hi Cynthia Thanks so much for the quick reply. Those sites will indeed do. The Arial down arrow is hex 2193 and looks fine on the graph. Much appreciated! Ben

BenConner · ‎03-02-2017

Hi, I have a template that uses the unicode 1F811B (heavy down arrow) outside a rectangle that gets drawn. It is part of the Symbola font and I have to specify that for it to show up. Example: drawtext textattrs = (size = 10pt family = "Symbola" color = &dkblue. ) {unicode '1F81B'x} / ...; The problem with this approach is when going to a PDF file, this font must be present on the viewing machine in order for the PDF file to render properly. This isn't a universal font like Arial, so this will be a problem. Is there a workaround to getting the down arrow to appear? This is being generated in Win 64 9.4 TS1M3. Thanks! --Ben

Online Status	Offline
Date Last Visited	‎06-06-2023 11:03 PM

Re: execution timing of macro generated code vs macro invocation.

execution timing of macro generated code vs macro invocation.

Re: "File is in use" error when reading an external file

Re: Insertbuff= option for SAS SQL Pass-through?

Re: Insertbuff= option for SAS SQL Pass-through?

Re: Insertbuff= option for SAS SQL Pass-through?

Re: Insertbuff= option for SAS SQL Pass-through?

Re: Insertbuff= option for SAS SQL Pass-through?

Re: Insertbuff= option for SAS SQL Pass-through?

Insertbuff= option for SAS SQL Pass-through?

Re: member level reading in ZIP Access method doesn't work with fileva...

Re: ODBC to MS SQL server permissions

Re: Proc Report refinement with style and title management

Re: how to read filenames of a directory into a file

Re: ERROR: Key not found. when using hash tables...how to suppress?

Re: SAS Support policies

Re: Thoughts on using SAS compression

Re: Executing SQL Server procs from SAS

Re: Mixing SPDE files with non-SPDE SAS datasets

Re: Does excel destination use only one by variable with the sheet_int...

Re: Inline formatting swallows a space when going to Excel

Re: Inline formatting swallows a space when going to Excel

Inline formatting swallows a space when going to Excel

Re: Dataflux functionality in base SAS?

Re: Dataflux functionality in base SAS?

Re: Dataflux functionality in base SAS?

Dataflux functionality in base SAS?

Reading a text file with embedded EOF characters in it

Re: Creating a scale for a GMAP map output

Creating a scale for a GMAP map output

Re: Replaying a group of graphs to a gridded layout

Re: Replaying a group of graphs to a gridded layout

Replaying a group of graphs to a gridded layout

Re: Unicode concepts

Unicode concepts