topic Re: PROC MEANS display in SAS Procedures

PROC MEANS display

Gladis6680 — Fri, 05 Jul 2019 20:15:42 GMT

Hi there,

I have written this code for a simple proc means

proc means data=have SUM stackodsoutput;

var E F;

class A B C D;

run;

and I am getting this

A	B	C	D	Variable	Sum
Yellow	Yes	Italy	Coffee	E	$10
				F	3
Yellow	Yes	London	Milk	E	$100
				F	3
Green	Yes	Ireland	Whole Milk	E	$25
				F	3

what I would like is

A	B	C	D	E	F
Yellow	Yes	Italy	Coffe	$10	3
Yellow	Yes	London	Milk	$100	3
Green	Yes	Ireland	Whole Milk	$25	3

to have the var variables side by side instead of one below the other. Is that possible.

I would appreciate your help.

Thanks

Re: PROC MEANS display

Reeza — Fri, 05 Jul 2019 20:19:25 GMT

STACKODS affects the tables not the displayed output. I'm not aware of a way to get that output in PROC MEANS but you could use PROC TABULATE or REPORt if you wanted. Or you can pipe your results from PROC MEANS to a table and print that.

It all depends on what you're doing this for and the next steps.

Re: PROC MEANS display

Gladis6680 — Fri, 05 Jul 2019 20:39:42 GMT

Thank you! Let me try PROC TABULATE OR PROC REPORT

Re: PROC MEANS display

Ksharp — Sat, 06 Jul 2019 11:52:16 GMT

You missed option NWAY ,since you are using CLASS.

proc means data=have SUM stackodsoutput NWAY;

Re: PROC MEANS display

Gladis6680 — Mon, 08 Jul 2019 14:16:51 GMT

Thank you !

I have used PROC REPORT to get the table in the format that I wanted

proc report data=have;

column A B C D E F;

define A/group;

define B/group;

define C/group;

define D/group;

define E/analysis sum;

define F/analysis sum;

run;

But I would like the E and F variables in the descending order, is there a way to do that.

Thank you very much!

Re: PROC MEANS display

Reeza — Mon, 08 Jul 2019 15:49:35 GMT

I believe there's an ORDER option on the DEFINE statement.

Re: PROC MEANS display

Ksharp — Tue, 09 Jul 2019 11:40:45 GMT

It is interesting. Looks like ORDER= option in PROC REPORT is not working . Try PROC SQL.

proc sql;
select age,sum(weight) as sum
 from sashelp.class
  group by age
   order by 2 desc;
quit;

Re: PROC MEANS display

Tom — Tue, 09 Jul 2019 13:34:30 GMT

@Gladis6680 wrote:

Thank you !

I have used PROC REPORT to get the table in the format that I wanted

proc report data=have;

column A B C D E F;

define A/group;

define B/group;

define C/group;

define D/group;

define E/analysis sum;

define F/analysis sum;

run;

But I would like the E and F variables in the descending order, is there a way to do that.

Thank you very much!

How can they both be descending?

Do you mean you want it descending by E and then within the value of E descending by F?

You probably need to summarize first and then make a report.

proc summary nway data=have ;
 class a b c d;
 var e f ;
 output out=summary sum= ;
run;
proc sort data=summary ;
  by descending e descending f;
run;
proc print data=summary;
  var a b c d e f;
run;