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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.