I prefer this could be done by using proc report,
Thanks a lot!
data have;
input x y;
cards;
1 2
1 1
5 2
0 3
3 1
1 3
1 3
0 1
6 5
1 0
4 2
1 4
0 1
;
data want(in SAS or excel format )
1 2
1 1
5 2
0 3
3 1
1 3
1 3
0 1
6 5
1 0
4 2
1 4
0 1
28
filename tmp temp;
ods tagsets.excelxp file=tmp style=minimal;
data have;
input x y;
cards;
1 2
1 1
5 2
0 3
3 1
1 3
1 3
0 1
6 5
1 0
4 2
1 4
0 1
;
run;
proc print data=have noobs;
var x y;
sum y;
run;
Hi George S.,
Below is some very basic proc report code to do what you asked.
data have;
input x y;
cards;
1 2
1 1
5 2
0 3
3 1
1 3
1 3
0 1
6 5
1 0
4 2
1 4
0 1
;
proc report data = have nowd out=want(drop=_:);
columns x y;
define x / display;
define y / analysis;
rbreak after / summarize;
run;
I somehow missed the desire to use proc report. My mistake.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.