blah is a character variable mostly populated with numbers in dataset fred.   if I do this ...    data fred2;       set fred;       if sum(blah) ^= .;    run;   ... SAS will give me just those records which don't have just numbers in blah. However, if I try something like this ...    proc tabulate data=fred;       where sum(blah) ^=.;       .       .       .    run; ... SAS complains with the error: ERROR: Function SUM requires a numeric expression as argument 1. Is there any way I can avoid that additional data step above and still filter on sum(blah) ^=. directly in the PROC? ... View more

As the title says, I'd like to put a tab into the title or footnote of a spreadsheet coming out of ODS Excel. Now this can be easily done with ODS RTF, e.g.:    ods escapechar='^';    title  "^R/RTF""\tab""   ";   But I can't for the life of me work out how to do it for ODS Excel.   I know about {nbspace N} where N is the no. of spaces to insert, (example: footnote "Version:^{nbspace 3}1"; but I really want tabs!   I also tried this:    footnote "Author:" '09'x "Fred"; but it had no effect.   Any help greatly appreciated!     ... View more

So I ran this little piece of code under SAS9.4 M0 and also under M3 and get a different name for the colpctsum variable!   proc tabulate data=sashelp.cars out=fred;    var horsepower;    class origin;    table origin,horsepower*colpctsum; run;   Under M0 the var name is: Horsepower_PctSum_0 Under M3 the var name is: Horsepower_PctSum_0_Horsepower   This is very unfortunate and is causing us a lot of grief!   Is there anything in the release notes that refers to this new behaviour?   Thanks   ... View more