Hi I have categorical data in mulitple columns like this:   ID T1 T2 T3 T4  M1 M2 M3 1 NN NN YN NN YY NY NN 2 YN NN YN YN NY YN NN 3 YY YY YN YY NY YN NN 4 NY YY NY NY YN NN NN 5 NN NN YN NN YY NY NN 6 YN NN YN YN NY YN NN 7 YY YY YN YY NY YN NN 8 NY YY NY NY YN NN NN The categorical values (NY,NN, YN, and YY) are the same in each of the columns. I would like aggregated count output for the categories in each column as a single table, like:   T1 T2 T3 T4  M1 M2 M3 NN 2 4   2   2 7 YN 2   6 2 2 4 1 YY 2 4   2 2     NY 2   2 2 4 2     Can anyone suggest some code that would do this?   Appreciate your help,   Celia. ... View more

Hi everyone, I was wondering if anyone knows of a way to display the output from proc tabulate to the nearest 100, or a format that I could apply?  At the moment, I'm outputting to an excel spreadsheet and using the rounding function in excel, but it's pretty tedious. Cheers, Celia. ... View more

I'm trying to pull out the last two digits of a year.  I used the following code, but i get the answer of 65.  Can anyone suggest a way I could do this? %let yeartest=2002; %let yeartest2=%sysfunc(putn(&yeartest,year2.); I would like to have as the result a variable storing 02 Thanks, Celia. ... View more

Hi everyone, I'm using proc tabulate and my class variable contains organisation names that are around 60 chars long.  The default output is to wrap the text over multiple lines.  is there any way to specify the width of the column so these don't wrap? Thanks, Celia. ... View more