About wcp_fnfg

wcp_fnfg · ‎09-08-2014

It seems that if there are no records in a tabulate that it doesn't output anything. This is in contrast to the scenario where I have preloadfmt\printmiss and can get rows\columns even for missing values. Is there a way around this? In this example, if I set where letters = 'D' then I get a 3 column table, but with letters = 'E', I get nothing. I'd like to still get 3 columns with this table. Any thoughts? Classdata with a dummy table hasn't worked for me either. data dummy; do numbers = 1,2,3,4; do letters = 'A','B','C','D'; output; end; end; run; proc format; value $L 'A'='A' 'B'='B' other = 'X'; run; proc tabulate data=dummy missing; where letters = 'E'; class letters/preloadfmt; var numbers; tables (letters='')*( numbers * sum='' *f=comma24.0 ) /printmiss; format letters $l.; run;

wcp_fnfg · ‎08-04-2014

I've read a few articles about tagset.tableeditor to create pivot tables in excel, but they don't work for me. Pressing the Export button causes a crash, plus having the unnecessary step of loading IE before I can get my output is much less than ideal. Does anyone have an alternative?

wcp_fnfg · ‎07-31-2014

Yup that works. Any idea how to style that text, like bold, italics, weight, etc?

wcp_fnfg · ‎07-28-2014

I can use data _null_ and file print, but not matter what, when it shows up in excel, it has a period in front of the text. Any alternatives\fixes? data _null_; file print; put 'Hi Wes'; run; Ends up as .Hi Wes (The period is not present in the output window, just excel. EG5.1

wcp_fnfg · ‎07-08-2014

Thanks for the reply. That works, but I'm hoping to feed use a computed report variable to do my obs... I may have to add a few steps to do it, essentially, that way though.

wcp_fnfg · ‎07-08-2014

Would like to cap my report at the top X observations. Like if I had 10 students heights and only wanted to out the top 5 tallest. Any thoughts?

wcp_fnfg · ‎06-26-2014

proc template; define style styles.lucy; parent=styles.normal; style Body from Body / Pagebreakhtml='<BR> <BR>'; class header / borderleftwidth = 1px bordertopwidth = 1px borderleftcolor = #000000 bordertopcolor = #000000 borderrightcolor = #000000 borderbottomcolor = #000000 ; class data / borderleftcolor = #000000 bordertopcolor = #000000 borderrightcolor = #000000 borderbottomcolor = #000000 ; end; run;

wcp_fnfg · ‎06-26-2014

Attaching the output spreadsheet (minus data for security). This is my template, but nothing seems to change the border color... proc template; define style styles.Lucy; parent = styles.normal; replace Header from Header/ bordercolor = red borderstyle = dotted; replace Table from Table/ bordercolor = black; replace Data from Data/ bordercolor = black; replace Default from Default/ bordercolor = black frame = box; end; run;

wcp_fnfg · ‎06-26-2014

I know it's something like this, but I used that and my output is still blue borders and has no top\left borders. FWIW, I'm on EG5.1

wcp_fnfg · ‎06-26-2014

Really just trying to do two changes to the normal style: Change all border colors from blue to black Border the entire box (top and left edges have no border now) I'm using ODS Tagsets.ExcelXP and Proc Report\Tabulate for outputs. Thanks!

wcp_fnfg · ‎04-01-2014

Throwing this in the mix, uses summary statistic only to get rid of duplicates. proc sql; create table c as select id, b.month, max(case when a.month = b.month then loss else . end) as loss from a, b group by id, b.month; quit;

wcp_fnfg · ‎04-01-2014

That got me the list of ID and month, but not the loss. I could merge this table back to the starting one though.

wcp_fnfg · ‎04-01-2014

3724 proc sql; 3725 create table want as 3726 select * from 3727 (select distinct id from a 3728 cross join 3729 select distinct month from b ----- 22 76 ERROR 22-322: Syntax error, expecting one of the following: ), ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored. 3730 ) as cross_joined 3731 order by id, month; 3732 quit;

wcp_fnfg · ‎04-01-2014

Looking to create a table which contains ID records for each possible months (table B). Any thoughts? I think this is a short SQL cartesian join, but I can't get the syntax clean. data a; input id $ month loss; datalines; 123 201302 5 123 201306 14 ; run; data b; input month; datalines; 201301 201302 201303 201304 201305 201306 201307 201308 201309 201310 201311 201312 ; run;

wcp_fnfg · ‎03-28-2014

I am looking for a way to tell excel "put a page break at this row" using an output with excelxp and proc report. Thanks!

Online Status	Offline
Date Last Visited	‎10-13-2016 10:57 AM

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Creating a multiple sheets Excel output with ODS

Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Proc Report: Groups in Columns, Vars in Rows?

Re: Proc Report: Groups in Columns, Vars in Rows?

Proc Report: Groups in Columns, Vars in Rows?

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Proc Report - Conditional Subtotal?

Losing Styles converting ODS Tagset.ExcelXP to ODS Excel

Re: Output Blank Tabulate

Output Blank Tabulate

Pivot Tables without HTML?

Re: Print Line of Text to Tagsets.ExcelXp

Print Line of Text to Tagsets.ExcelXp

Re: Proc Report - Top X Observations?

Proc Report - Top X Observations?

Re: Use Proc Template to Modify styles.normal?

Re: Use Proc Template to Modify styles.normal?

Re: Use Proc Template to Modify styles.normal?

Use Proc Template to Modify styles.normal?

Re: Match ID to list of months to get record for all months (SQL Carte...

Re: Match ID to list of months to get record for all months (SQL Carte...

Re: Match ID to list of months to get record for all months (SQL Carte...

Match ID to list of months to get record for all months (SQL Cartesian...

Tagsets.ExcelXP - Custom Page Break