I tried the UNIVARIATE approach on a wide table of 7500 columns (35 rows), and UNIVARIATE ran in 300s.  All other techniques I tried on this table ran much much slower.  I think the Univariate approach is very powerful.  Here is my code just as an example.     ods listing close; ods output frequencies=_afreq; proc univariate data=sashelp.cars NEXTRVAL=20 freq; var _numeric_; run; ods listing; ... View more

Hi:     Pretext and posttext can do this. For example: ods rtf file="&path.\one.rtf" style=custom bodytitle; proc report data = test nowd split='#' missing style = [outputwidth = 9in]  style(header)=[asis=on just=left protectspecialchars=off]           style(column)=[asis=on protectspecialchars=off]          style(report)=[pretext='Chemistry Data'  posttext='Reference Range used is local laboratory Reference Range{\par}H= high{\par}L= low{\par}A= abnormal'  just=left font_weight=light font_size=12pt]; ods rft close; ... View more

Just as NickR said. You need to put sex variable(noprint) before new variable. ods escapechar='^'; ods pdf file='temp.pdf'; proc report data=sashelp.class nowd ;       column sex age new name;       define sex/noprint;       define new / format=$30. ;       define name / display;       compute new/char ;             if sex = "M" then new='^S={font_face=wingdings} ²'; else new='^S={font_face=wingdings} ²²²²²²';       endcomp; run; ods pdf close; Ksharp ... View more

another way to change Character variable to numeric variable,     Char_Var *1; or  Char_Var+0; ... View more

How about : [pre] libname xls excel path='c:\test.xls' header=no; proc sql; create table xls as select * from xls.'Sheet1$'n; quit; [/pre] Ksharp ... View more