About wcpatton

wcpatton · ‎03-16-2012

All I seem to be able to get is the raw numbers. I'm trying to get the sum to show up like currency with Dollars and commas (at least commas) and the pctsum to show up like a percent. I can get the commas with tagattr or I can get the percent without tagattr, but I can't find a way to get both. Any help? ods listing;title; options missing = ''; ods tagsets.excelxp file= "c:\junk.xls" style=normal options (SHEET_INTERVAL="NONE"); ods tagsets.excelxp options (Sheet_Name = "Portfolio"); proc tabulate data=delq1 missing; class portfolio monthend delq; var totalbalance; tables (portfolio='' all='')*( totalbalance = "Balance" *sum='' *f=comma24.0 totalbalance = "Rate" *colpctsum='' *f=percent24.2 ),(delq='' all) ,(monthend='') / box = '' row=float; format delq delq.; run; ODS TAGSETS.EXCELXP CLOSE;

wcpatton · ‎11-07-2011

Trying to get tabulate to "ignore" that the criteria returns no results. For example, if the id_category isn't in the data set, I'd still like the whole empty table output (zero or missing in every cell). Anyway I can get tabulate to do this or to trick it in the data? Thanks! :smileyplus:

wcpatton · ‎10-28-2011

Hello. When I open a second session, I lose all of my configurations such as my KEYS layout and my explorer settings (view tree, list, etc). How can I have two sessions active with the same user configurations?

wcpatton · ‎07-14-2011

By using dictionary.members instead of dictionary.tables, it's now lightning fast. Wooo. Thanks everyone! :smileygrin:

wcpatton · ‎07-14-2011

This works great, brilliant piece of code. Any way to speed up the first step, though? Is there any thing that would stop the process once it has identified the sheet name? It runs for a while on these large workbooks, like it is reading the whole sheet into memory.

wcpatton · ‎07-11-2011

I don't see how I would join those into one file then. The myxl folder contains each of the worksheets, but then how to join them? Is there a function to set all files in a directory together?

wcpatton · ‎07-11-2011

Hello! I am looking for a way to import all of the worksheets in an excel book without specifying the names of those sheets. Ideally, they would all be then joined to make one large dataset. I imagine there has to be a macro that can handle this....

wcpatton · ‎07-06-2011

In this code, the resulting tabulate should rank C then A then B. data one; input seg $ bal; datalines; a 1 a 2 a 3 b 1 b 1 c 15 ; run; proc tabulate data = one; class seg /order=freq; var bal; tables seg , bal = "Balance" *sum='' *f=comma24.0 ; run;

wcpatton · ‎07-06-2011

Any way this can be done? Say I have a data set with segments and balances, I want to order the table by the sum of the balances. I.e. the highest balance segment would be listed first. Order=freq only would work if the balances are proportionate to the units. Thanks!

wcpatton · ‎05-12-2011

Does anyone have a macro utility or procedure that can convert the longform windows file names to the short form dos version? For example, the path c:\program files becomes something like c:\progra~1. Also this takes place at the file name level as well where "one two three four.xlsx" ends up something like onetwo~1.xls. Thanks.

wcpatton · ‎04-25-2011

So it seems that no matter what I do, there ends up being blank space between my titles on the ToC that can be clicked on, causing the procedure name to disappear\collapse. Any way to disable this behavior? Ideally, my ToC\Frame would only have the links to the appropriate section of the report. Thanks.

wcpatton · ‎04-22-2011

I knew it had to be something simple. Thanks!

wcpatton · ‎04-22-2011

Is there an option that will disable the automatic opening of the files produced by my ods html? I know about the menu option, but I'd like to write it into the program. Thanks.

wcpatton · ‎04-21-2011

Perfect, thanks!

wcpatton · ‎04-21-2011

So I can reference the PDF named references, but I can't seem to edit them in the fashion that I would edit a bookmark (ods proclabel "&name.";) By default, the PDF's destinations are named IDX1, IDX2, etc. Is there a way to change the IDX names to something custom or alternately is there a way to link directly to the proc label? Thanks.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Tabulate, Tagsets.ExcelXp and Dates

Re: POSTTEXT with Tagsets.ExcelXP

POSTTEXT with Tagsets.ExcelXP

Re: Tabulate, Compound Box = ?

Re: Tabulate, Compound Box = ?

Re: Tabulate, Compound Box = ?

Re: Tabulate, Compound Box = ?

Tabulate, Compound Box = ?

Re: Tabulate, Tagsets.ExcelXp and Dates

Re: Tabulate, Tagsets.ExcelXp and Dates

ODS MARKUP: add the ability to modify the worksheet tab colors with th...

Import all Excel Worksheets

Re: Tagsets.excelxp Error (9.3)

ODS Tagset to Excel: Commas for Thousands and % for Percents

Proc Tabulate - Output with no observations

Multiple SAS Session - Keep User Settings

Import all Excel Worksheets

Import all Excel Worksheets

Import all Excel Worksheets

Import all Excel Worksheets

Proc Tabulate - Order by Statistic

Proc Tabulate - Order by Statistic

Convert Long filename to Short (Dos) filename

ODS HTML - ToC and Frame File

Re: Disable File Opening Temporarily

Disable File Opening Temporarily

Re: Assign #nameddest with ODS PDF

Assign #nameddest with ODS PDF