topic Using of GROUP in SAS Programming

Using of GROUP

vishyy — Thu, 27 Apr 2017 07:16:28 GMT

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

Re: Using of GROUP

vishyy — Thu, 27 Apr 2017 07:21:50 GMT

Sample Dataset is attached.

Re: Using of GROUP

PeterClemmensen — Thu, 27 Apr 2017 07:35:33 GMT

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;

Re: Using of GROUP

Kurt_Bremser — Thu, 27 Apr 2017 07:34:06 GMT

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

Re: Using of GROUP

vishyy — Thu, 27 Apr 2017 08:41:06 GMT

I dont want to use proc sql.

Re: Using of GROUP

RW9 — Thu, 27 Apr 2017 08:48:18 GMT

Use proc means with a by group then.

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

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

Re: Using of GROUP

Kurt_Bremser — Thu, 27 Apr 2017 08:49:08 GMT

@vishyy wrote:

I dont want to use proc sql.

Why?

See Maxim 14.

Re: Using of GROUP

PeterClemmensen — Thu, 27 Apr 2017 08:54:22 GMT

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;

Re: Using of GROUP

vishyy — Thu, 27 Apr 2017 08:55:43 GMT

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

Re: Using of GROUP

vishyy — Thu, 27 Apr 2017 08:57:01 GMT

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

Thanks for nudging.

Re: Using of GROUP

RW9 — Thu, 27 Apr 2017 09:03:42 GMT

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.

Re: Using of GROUP

Kurt_Bremser — Thu, 27 Apr 2017 09:11:28 GMT

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