Using of GROUP

[vishyy]

Hi

I am new to SAS, Please hlp me in resoving a sample business problem.

I have sample records below .

I need to find the total usage of each customer for Home and roaming circle.

Thanks 

[vishyy]

Sample Dataset is attached. 

[PeterClemmensen]

Please post your data in the form of a datastep, mush easier to help that way

This is not tested but you are probably looking for something like this

proc sql;
	create table want as
	select circle
	      ,sum(minutes)
	from have
	group by circle;
quit;

[vishyy]

I dont want to use proc sql.

[RW9]

Use proc means with a by group then.  

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n0k7qr5c2ah3stn10g1lr...

Also, try not to limit yourself with what tools you can and can't use, they are all useful.

[vishyy]

I am new and learning SAS, i just want to do in that way nothing else.

[RW9]

In what way, please be specific.  You have said GROUP which indicates SQL, then you say you don't want to use that.  So the next option is using a procedure designed to create means output - proc means, however this also doesn't seem to fit what you want.  So please be clear in your posts exactly what it is you want so we don't go through these loops of trying to figure it out.  

[Kurt_Bremser]

---

@vishyy wrote:

I dont want to use proc sql.

---

Why?

See Maxim 14.

[vishyy]

I am new and learning SAS, i just want to do in that way nothing else.

Thanks for nudging. 

[Kurt_Bremser]

And you still have not provided example data in a usable form.

[PeterClemmensen · Accepted solution]

Gotta say, not very clear from your subject line "Using of Group".

Here is a datastep solution, again, not tested.

proc sort data = have;
	by circle;
run;

data want;
	set have;
	by circle;
	sum = sum + minutes;
	if last.circle then output;
	retain sum 0;
run;

[Kurt_Bremser]

A macro for semi-automatic conversion of a dataset to a data step can be found here.