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
Thank you! Let me try PROC TABULATE OR PROC REPORT
You missed option NWAY ,since you are using CLASS.
proc means data=have SUM stackodsoutput NWAY;
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!
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;
@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;
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.