customizing proc means output

BStats — Thu, 05 Nov 2015 20:25:59 GMT

Hi-

I am currently work on a report that will involve ods rtf output for clients. A section of my code includes a proc means statement with a class variable. Similiar to this........

proc means nolabels data=mydata n mean;

class company;

var OpTime;

output out=meansdata;

run;

Which produces output that looks like this..........

OpTime

Company NObs N Mean

CompanyA 18343 18343 64.87

CompnayB 152 152 75.59

However, I need the class variables to be next to each other in the output not on top of each other. Needed output..........

Company A Company B

OpTime N Mean N Mean

18343 64.87 152 75.59

I have tried using proc transposed and keep getting the same error message........

"data set work.meansdata is not sorted in ascending sequence. The current BY group has"

Any thoughts are wanted. Thank you.

Re: customizing proc means output

data_null__ — Thu, 05 Nov 2015 20:32:43 GMT

PROC TABULATE

Re: customizing proc means output

BStats — Thu, 05 Nov 2015 20:46:11 GMT

I got it. I was missing NOSEPS. Thanks!

topic customizing proc means output in ODS and Base Reporting

customizing proc means output

Re: customizing proc means output

Re: customizing proc means output