topic Re: SAS create a table with a loop in SAS Programming

SAS create a table with a loop

nridwan — Mon, 14 Sep 2015 21:46:29 GMT

Dear all,

I just started to learn and use SAS… I’am currently facing a problem and hope someone would be able to help me.

I have a database of the following form :

What I would like is to create a table that will contains the number of observation per group. So something like :

I am trying to work with a loop that will complete progressively the table but after many trials i am unable to do so… Does someone has an idea ?

Thank you very much

art297 — Mon, 14 Sep 2015 21:58:50 GMT

Proc summary is nice to use for such situations. e.g.,

proc summary data=have nway;
class model;
var option1-option3;
output out=want (drop=_:) sum=;
run;

arodriguez — Tue, 15 Sep 2015 06:21:54 GMT

An other way to do the same, is create the summary with SQL.

PROC SQL;

create table summary as(

select model, sum(option1) as option1, sum(option2) as option2, sum(option3) as option3

from have

group by model /*This option make the sum by model*/

);

QUIT;