topic Re: Can't get a simply BY grouping to work. Please help! in SAS Programming

Can't get a simply BY grouping to work. Please help!

hfakoor — Thu, 24 Nov 2016 14:36:23 GMT

Hello I havent used SAS in a while, and want to attain a basic programmer cert.

I'm trying to get this grouping to work from sashelp.cars but it is giving me all 128 observations in the output. I see repeated valuesfor the BY variable make

proc sort data=sashelp.cars out=work.temp2 (keep = make);
by make;
run;
proc print data = work.temp2;

any suggestions?

Re: Can't get a simply BY grouping to work. Please help!

RW9 — Thu, 24 Nov 2016 14:40:37 GMT

Yes, by group just means to do something for each group specified, it doesn't remove any variables. Perhaps you mean to sort the dataset using nodupkey:

proc sort data=sashelp.cars out=work.temp2 (keep = make) nodupkey;
  by make;
run;
proc print data = work.temp2;
run;

The nodupkey options will remove any subsequent observations from each by group.

Re: Can't get a simply BY grouping to work. Please help!

hfakoor — Thu, 24 Nov 2016 14:44:28 GMT

thanks so much-

If I wanted to sum msrp against Make grouping how would I go about that?

my code below is still giving me all 428 obs in the output.

proc sort data=sashelp.cars out=work.temp2 (keep = make msrp);
by make;
run;
proc print data = work.temp2;
sum msrp;
run;

Re: Can't get a simply BY grouping to work. Please help!

hfakoor — Thu, 24 Nov 2016 14:50:11 GMT

this seemed to work.

proc sort data=sashelp.cars out=work.temp2 (keep = make msrp) nodupekey;
by make;
run;
proc print data = work.temp2;
sum msrp;
run;

coming from the world of sql I was really looking for a way to just group the output and supress repeated by variables as opposed to supressing them in the output data itself.

Is there a way to do that?

Re: Can't get a simply BY grouping to work. Please help!

RW9 — Thu, 24 Nov 2016 14:52:43 GMT

The option is nodupkey.

If your familiar with SQL then use proc sql:

proc sql;
  create table WANT as
  select  MAKE,
          sum(MSRP) as RES
  from    SASHELP.CARS
  group by MAKE;
quit;