About BenConner

BenConner · ‎04-12-2013

Hi, Excel has an annoying habit of truncating a long character field when all the bytes in the field are numeric; it thinks it is a numeric value and truncates anything past 16 digits. I have a 20 byte character key field that at times has an all-numeric key value. Anyone have a clever way to tell Excel to retain the character interpretation and not try to convert it to a number? I was able to do this by enclosing the field in double quotes, but would like a cleaner solution if one is available. Thanks! --Ben

BenConner · ‎12-06-2012

Thank you so much! Had tried that but I think I was typing in -minpartsize 2000m rather than an upper case M. In any event, it didn't throw an error. Much appreciated! --Ben

BenConner · ‎12-06-2012

Hi, For SAS 9.1.3 and the SPDE engine, does the partsize= data set option exist? Can someone give me an example of how it is specified? I've tried numerous variations (partsize=3G, partsize=3000000000, etc.) and all of them throw an error. Thanks! --Ben

BenConner · ‎08-28-2012

Outstanding! Thanks very much! --Ben

BenConner · ‎08-28-2012

Hi, I defined an OLAP cube with drill-down capability and tried to access the underlying detail in SAS EG. It couldn't display the detail as it didn't have access to the format library I had defined. Where do I declare that? Is this something that has to be done by the SAS admin for the site? Thanks! --Ben

BenConner · ‎07-03-2012

Hi Alpay, Outstanding! Thank you very much! Had no idea the style attribute could be used in so many places. --Ben

BenConner · ‎07-03-2012

Hi, I have a proc tabulate whose target is a web page. The default colors for the row and column headings/categories are blue. Is there a way to override the text color to default to black? Thanks much! --Ben ods html file='....html'; proc tabulate data=matched out=temp; class prev curr mig; table prev=' '*(n=' '*f=comma9. rowpctn='%'*f=pcts.),(curr="&cmon &cyear" all='Total') mig / box="&pmon &pyear"; run; ods html close;

BenConner · ‎06-22-2012

OH! Yes, one of the find() was w/o a rc= context. Didn't realize that would generate a 20 meg log file. Much appreciated! --Ben

BenConner · ‎06-22-2012

Hi, I'm using 3 hash tables in a data step to pull in data for a large dataset. In many cases the key won't be found, and in those situations I just want to ignore the condition. What I'm seeing is each time this happens, an error gets sent to the log file in the form of: ERROR: Key not found. I didn't spot any obvious way to suppress these. ?? Thanks! --Ben

BenConner · ‎05-16-2012

Oh! I hadn't thought of using the overlay facility. Good idea! I'll give that a shot. Thanks! --Ben

BenConner · ‎05-16-2012

Hi, Thanks for taking a stab at it. I have tried re-ordering the data and the Symbol(n) statements with no change in the graph. May need to open a ticket with the Graph folks. --Ben

BenConner · ‎05-15-2012

Hi, I'm sure this has been answered before but I'm not even sure what to search on. When you have a graph displaying multiple lines (say sales by month and year, with the months along the x axis and each line on the graph representing a year), how do you control which line is 'on top'? It would be nice to see the most recent year on the top if the data is close from one year to the next. The graph in question uses spline smoothing in a set of SYMBOLn statements with different symbols (star, triangle, etc.) to represent the data points. Currently some 2012 month points are buried by prior year points. These are displayed as html graphs so hovering over the month in question returns the prior year value. Thanks! --Ben

BenConner · ‎03-06-2012

Hi, Found the issue: the SAS docs use single quotes in their examples; using double quotes resolved the syntax problem. I'm not sure if this is an issue with the install locally or something else. Very strange. Thanks very much for your help! --Ben

BenConner · ‎03-05-2012

This is actually running under 9.1.3, so it may have changed going to 9.2. The different values (according to page 273 of the SAS/Access for Relational Databases (9.1.3) are: ’,,,d’ ’,,d,’ ’,,,s’ ’,,,sa’ ’,,t,’ off I picked the first one. --Ben

BenConner · ‎03-05-2012

Hi, Do you have indexes created on the keys you are comparing against? That should help, especially if the # of rows in each table is significantly different. --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...

Preserving long numeric values in tagsets.excelxp generated spreadshee...

Re: 9.1.3 SPDE partsize option?

9.1.3 SPDE partsize option?

Re: Where do I store user defined formats in an OLAP cube for drill-do...

Where do I store user defined formats in an OLAP cube for drill-downs?

Re: Row/column headings colors in tabulate

Row/column headings colors in tabulate

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

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

Re: Controlling which plot lines are on top in a x*y=z graph

Re: Controlling which plot lines are on top in a x*y=z graph

Controlling which plot lines are on top in a x*y=z graph

Re: sastrace option

sastrace option

PROC SQL JOINS PERFORMANCE