Below is my proc tabulate code.  I'd like the first variable in the table, the page variable 'cohort', to print with vertical alignment to save space.   Can someone tell me how to do it?  I've searched far and wide and have not found an answer yet.    Bill   ****************   code  ******************** proc tabulate data =&input f=4.0 S=[just=c cellwidth=75];  var Col1; class cohort criterion instrument /ORDER=DATA ; class _name_ ; table cohort*instrument*criterion all={label='Total' s=[just=R background=lightblue]}*{s=[just=C background=lightblue]} ,(_name_='Level' ALL)*Col1=" "*(sum="N"*(f=cnum.) ROWPCTSUM="%"*f=mypct. ) /box=_PAGE_;  BY instrument NOTSORTED;  run;   ... View more

The Proc Tabulate code below generates good looking HTML files but when I change the ODS format to RTF or PDF they look like hell.   The biggest problem is that the rows containing the data are all squished so the numbers aren't readable.   I don't really want to have a different version of Proc Tabulate for each ODS output type but if that's the only solution I'll do it.    Also if I change the html file extension to .xls  it will open in Excel and look pretty good but Excel gives a warning message that the file is corrupt.   Any suggestions for either of those issues?   If I need to post sample outputs I'll be happy to.     --------------------   code ------------------- proc tabulate data =&input f=4.0 S=[just=c cellwidth=25];  var Col1; class criterion instrument /ORDER=DATA ; class _name_ ; table instrument*criterion all={label='Total' s=[just=R background=goldenrod]}*{s=[background=goldenrod]} ,(_name_='Level' ALL)*Col1=" "*(sum="N"*(f=3.0) ROWPCTSUM="%"*f=mypct. ) /box=&reportdate;  BY instrument NOTSORTED;  run;   ... View more

I am importing a lot of Excel files and creating reports.  One of the things I have to do is to sum the values of a variable.  The Sum function works with many of the files but some don't.   The errors I get on some of them are similar to this sample:     "ERROR: The SUM summary function requires a numeric argument. ERROR: The following columns were not found in the contributing tables: L5."   I've checked the datasets with Proc Contents and in every one one that throws this error, that variable is numeric.   Any ideas why I'm having this problem and more importantly, how to solve it? relevant SAS code below.  This is all inside of a set of macros.  The purpose of this macro is to see if all the values of the variable L5 are zero.  If they are, I create a text variable with L5 in it, and later use it in a DROP statement to drop the variable from the dataset.   %macro checkL5(source);  %global L5total; %global DROPLIST; proc sql; select sum(L5)into :L5total from &source; quit; %IF &L5total =0 %then %LET DROPLIST = L5; %mend checkL5;   I've tried this on SAS 9.2 and also with SAS 9.4 with the same results.   Thanks!   Bill ... View more

I am importing a lot of Excel files and creating reports using Proc Tabulate.   Many work but some don't.   The errors I get on some of them are similar to this sample:     "ERROR: Data set WORK.REPORT2NEWSORTEDLONG is not sorted in ascending sequence. The current BY group has Assessment Instrument  Name = ARED BS CAPS ST Final Candidate and the next BY group has Assessment Instrument Name = ARED BS CAPS ST Final CT."   I think I know why these are considered out of order, because SAS sorts capital letters before lower case ones, but I sorted these using Proc Sort ahead of time.    I also use the option  /ORDER=DATA  in the class statement of Proc Tabulate and I thought that would make the sort order irrelevant.   Any ideas why I'm having this problem and more importantly, how to solve it? relevant SAS code below.  This is all inside of a macro.  The dataset has been re-organized using proc transpose prior to this.   proc tabulate data =&input f=4.0 S=[just=c cellwidth=25];  var Col1; class criterion instrument /ORDER=DATA ; class _name_ ; table instrument*criterion all={label='Total' s=[just=R background=goldenrod]}*{s=[background=goldenrod]} ,(_name_='Level' ALL)*Col1=" "*(sum="N"*(f=3.0) ROWPCTSUM="%"*f=mypct. ) /box=&reportdate; BY instrument;  run;   I've tried this on SAS 9.2 and also with SAS 9.4 with the same results.   Thanks!   Bill   ... View more