The NLEVELS option in PROC FREQ will create a separate table regardless of how many variables you request. The number of columns in the table will depend on if the variable(s) have missing values or not. In the first case, Origin does not have missing values, so the table will only show the variable name and the number of unique levels. In the second case, where you chose all variables (or if you had chosen the Cylinders variable initially), you will see columns for Levels, Missing Levels, and Nonmissing Levels. The sum of the Missing Levels and Nonmissing Levels is Levels. There is also a column for Labels if any of the variables has a label assigned. ... View more

The CNTLOUT= option on the PROC FORMAT statement creates an output data set with all the variables associated with the $Typcode format. You can view this data set by adding the following: proc print data=typfmtout; run; ... View more

For some reason the l is being cut off from html. Just make sure the path ends in .html ... View more

Try this: http://support.sas.com/rnd/base/topics/odsrtf/rtf901.html ... View more

The following web site has additional information on creating a table of contents in RTF output: http://support.sas.com/rnd/base/topics/odsrtf/rtf901.html ... View more

Try the following PROC TABULATE code: proc tabulate data=final; class fyr admitsrc drg; var pats; table admitsrc*(drg all) ,fyr*(pats*sum pctn ); run; If this does not answer your question, I would suggest opening a tracking number with Technical Support by sending email to support@sas.com with your code, a sample of the output, and an explanation of the percentages you are trying to get. ... View more

The following sample code worked for me. The label is split appropriately. The TITLEs do not have blank lines in between and there is a blank line between TITLE2 and the beginning of the table. ods listing close; ods tagsets.excelxp file='test.xls' options(embedded_titles='yes'); proc print data=sashelp.class noobs split='/'; title1 'one'; title2 'two'; label age='Age in/years'; run; ods listing; ods tagsets.excelxp close; If you continue to have problems, I would suggest opening a tracking entry with Technical Support by sending your log and a sample of the output to support@sas.com. ... View more

The updated tagset should take care of both of these issues for you. You can download it from here: http://support.sas.com/rnd/base/topics/odsmarkup/ ... View more

Note the revised code below: proc means nway mean; class day; var depth; output out=new mean= / autoname; run; proc print data=new; run; ... View more

Try the following: proc means nway mean; class day; var depth; output out=new / autoname; run; proc print data=new; run; ... View more

The style attribute that affects the (Continued) text is called AFTERCAPTION. You can modify it with the following PROC TEMPLATE code: proc template; define style styles.test; parent=styles.printer; style aftercaption from container / font_size=6pt; end; run; ... View more

Try the following: proc template; define style styles.test; parent=styles.rtf; style table from output / frame=hsides rules=groups; style header from headersandfooters / background=_undef_ protectspecialchars=off; end; run; ods listing close; ods rtf file='test.rtf' style=styles.test; proc report data=sashelp.class nowd; columns ("\brdrb\brdrs\brdrw15 Line one" name) sex age weight height; run; ods listing; ods rtf close; ... View more