About wcpatton

wcpatton · ‎04-12-2013

Producing a tabulate output with tagsets.excelxp into .XML format. Worked fine under 9.2, but with 9.3 I get an excel error "Problems During Load. Problems came up in the following areas during load: Table". Anyone know how I can restore this to working order? If anyone with SAS is reading this, I'm not too pleased that I have to keep rewriting output codes due to this "upgrade".

wcpatton · ‎04-10-2013

If I disable Create HTML in the preferences,I get my excel output, results viewer still opens.

wcpatton · ‎04-10-2013

I'm running exactly the same code I was in 9.2, so it's not the code. It's something with the new system options that I need reset.

wcpatton · ‎04-10-2013

Andre, Running that code I get the results viewer window, but no excel output. Preferences - Results options do not seem to give me the opposite with any combination. I want No results viewer, output only to excel. I run the ODS once and get this kind of error: ERROR: A component of C:\SAS\Work\_TD5324_PC2UA2120QB8_\G:\REPORTS\fakename.xls is not a directory. ERROR: No body file. HTML output will not be created. If I run it again, then I get no error. WTF 9.3?

wcpatton · ‎04-09-2013

So far, I've got it working by adding -rsasuser to the sasv9.cfg. Not sure how to add the cfg location to the icon properties.

wcpatton · ‎04-09-2013

I don't want this window to open, but I can't seem to disable it while still having my ODS HTML outputs generate their spreadsheets..... Help!

wcpatton · ‎04-08-2013

I have the first session up, I want to open a second one so I can run two programs at once, etc. How can I accomplish this. As an aside, is it possible to hide the "variable name change" warning in 9.3 with proc import?

wcpatton · ‎08-10-2012

Cynthia, The table has three columns, but the data has 4 columns (vendor, fruittype, height, weight). This is all imaginary data to simplify an bigger, more complicated data structure. The measures could certainly change, I have some variables that I need to sum, others are mean, etc.

wcpatton · ‎08-09-2012

I see what you're going for there, it works pretty well for the 2x3 table... In actuality, my data is more like 12x12, so I have to figure out if it's worth coding all those and hope it never changes. I'm looking into doing two tabulates, outputting the data as a dataset then merging those back together.

wcpatton · ‎08-09-2012

Suppose my dataset is about fruits, it has two values for fruit: Apples and Oranges. Being so different, I've decided that I want to measure Oranges by Weight and Apples by Height. My data would then have 3 columns, plus a 4th for vendor. I'm looking for a way to present this data in a proc tabulate side by side. Something like: Oranges Apples Vendor Weight Height Jim 15 6 Sally 14 2 Any thoughts about the possibility of changing the vars used based on the class value?

wcpatton · ‎04-04-2012

ods listing; did not work to resolve this.

wcpatton · ‎03-30-2012

Is the ! really different than ctrl-break? I always thought they were the same.

wcpatton · ‎03-30-2012

Sometimes, but this one does not. I'll try that next time this happens and see if it works.

wcpatton · ‎03-29-2012

Program's running, I decide I want to cancel it so I ctrl-break and cancel submitted statements. After doing that a few times (twice or so), I no longer get updates in my SAS log. Any way to prevent that from happening or to reenable the log? Base SAS 9.2 Thanks.

wcpatton · ‎03-16-2012

Got it already. Posting for future searchers. Trick was specifying style.. ods tagsets.excelxp file='c:\temp\junk.xml' style=sasweb options (SHEET_INTERVAL="NONE" absolute_column_width = '14,11,6,6,6,6,6,6,6,6,6,6,6,6,6' embedded_titles='yes' TAGATTR="format:excel-format" fittopage='yes' orientation='Landscape'); proc tabulate data=delq1 missing; class portfolio monthend cycledelinquency; var totalbalance ; tables (portfolio='' all='')*( totalbalance = "Balance" *sum='' *f=comma24.0 *{style={tagattr="format:###,###,###"}} totalbalance = "Rate" *colpctsum='' *f=pct. ),(cycledelinquency='' all) ,(monthend='') / box = '' row=float; format cycledelinquency delq.; run; ods _all_ close;

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)

Tagsets.excelxp Error (9.3)

Re: Hide "Results Viewer" in 9.3

Re: Hide "Results Viewer" in 9.3

Re: Hide "Results Viewer" in 9.3

Re: Start 2nd SAS Session with same SASV9.cfg

Hide "Results Viewer" in 9.3

Start 2nd SAS Session with same SASV9.cfg

Re: Proc Tabulate: Different Vars based on Class Value

Re: Proc Tabulate: Different Vars based on Class Value

Proc Tabulate: Different Vars based on Class Value

Re: SAS Log doesn't update after ctrl-break stopping

Re: SAS Log doesn't update after ctrl-break stopping

Re: SAS Log doesn't update after ctrl-break stopping

SAS Log doesn't update after ctrl-break stopping

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