I have a situation where I am sending proc tabulate output to xml files. I have pctn as one of my columns. I have the following code to create a value with one number after the decimal place: style=[tagattr='format:##0.0'  just=r cellwidth=1in]; The problem is that excel is rounding up from two positions after the decimal point and I want to truncate. For example I have a pctn value of 3.35 that is being exported to excel as 3.4. I want it to export as 3.3. Is there any code I can put in SAS to have excel truncate instead of rounding the values. ... View more

I am runing proc tabulate using ODS to output to xml files for use in Excel. I am trying to count records with unknown values in the calculation of percents, but I don't want to print the unknown data (highlighted in red) in my proc tabulate output. For ease of reference, I have numbered the different columns 1 to 12. In the snippet of the output from proc tabulate, I need to count the 6 unknown records in column 4 in the total count in column 2, but I don't want to print columns 4 through 6. Basically I want to count in my total cases (column 2) the missing data (column 4) for the column variable, "Prior Disease" (columns 4,7,10), but I don't want to display the columns (4-6) associated with the missing values for the "PRIOR Disease" variable. If I don't use the missing option in proc tabulate, then the "Unknown Disease" (columns 6-8) don't print, which is what I want, but my totals in columns 2 and 3 goes down by 6, which I don't want to have happen. If I use the missing option in proc tabulate, then the "Unknown Disease" (columns 6-8) print, which I don't want, but my overall totals in column 2 and 3 are counted correctly, which I want. My code is below the table snippet. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Reporting Jurisdiction Total Cases Total Tested Positive Unknown Disease No Prior Disease Prior Disease Tested Positive Tested Positive Tested Positive No. % No. % No. % No. % State 1719 1608 158 9.8 6 0 0.0 1524 145 9.5 78 13 16.7 Below is my proc tabulate code: proc tabulate data=table47 format=4.1 missing; class jurisdic prevdisease; var inh suscdone cultpos; table all={label="State"} jurisdic, cultpos={label="Total Cases"} suscdone={label="Total Tested"} inh={label="Positive"}*(n pctn<suscdone>*[s=[tagattr='format:##0.0']]) prevdisease={label=""}*(suscdone={label="Tested"} inh={label="Positive"}*(n pctn<suscdone>*[s=[tagattr='format:##0.0']]))/ box={label='Reporting Jurisdiction' s=[just=l]} indent=4 ; keylabel n='No.'; keylabel sum=' '; keylabel PctN='%'; format prevdisease $t47prevdisease.; run; Thanks, Saul Kanowitz ... View more

Here is the code I am using for my inline italicizing for a footnote in preparation for a proc print using ods to an xml file for use in excel. footnote j=left height=8pt "Note: Denominators for computing rates are from the California Department of Finance, \{style [font_style=slant color=red] E-2 California County Population Estimates and Components of Change.}"; The color=red works, which I don't care about. I was just trying to make sure I had syntax correct. I have tried font-weight=italic, font_style=italic, just italic and I can't seem to get the later half of this footnote to italicize. It prints red, but not italic. Any solution would be greatly appreciated. ... View more