Vertical Summation. Any help appreciated!

DDaugaard — Sat, 29 Nov 2014 19:27:30 GMT

Hi all!

I'm currently stuck with a SAS issue regarding Vertical Summation which I hope someone might be able to solve for me

I have a lot of information regarding different products which I have tried to illustrate beneth.

Ordernumber	Color	Customer name	XXX
212913	Blue	Jones	3
212913	Red	Jones	3
212913	Blue	Jones	3
212888	Green	Carina	2
212888	Yellow	Carina	2

What I am seeking is to create a new variable with the information on the size of the order the product was sold in.

Basicly I'm looking for is a function to summarize the amount of times ordernumber appears and then create a new variable telling me the size of the order the product was sold in (Illustrated by the name XXX, this could have been replaced with Ordersize).

Any help is much appreciated.

Thanks

Re: Vertical Summation. Any help appreciated!

Reeza — Sat, 29 Nov 2014 19:53:53 GMT

proc sql;

create table want as

select *, count(*) as OrderSize

from have

group by OrderNumber;

quit;

Re: Vertical Summation. Any help appreciated!

DDaugaard — Sun, 30 Nov 2014 09:54:39 GMT

Works like a charm! Thanks

topic Vertical Summation. Any help appreciated! in SAS Programming

Vertical Summation. Any help appreciated!

Re: Vertical Summation. Any help appreciated!

Re: Vertical Summation. Any help appreciated!