topic Re: cumulative sum for height in proc sql in SAS Procedures

cumulative sum for height in proc sql

BrahmanandaRao — Wed, 06 Nov 2019 10:05:53 GMT

Hi Good Eveyone

How to find cumulative sum for height in class library

using proc sql

data dsn;
set sashelp.class;
run;

proc sort data=dsn;
by age;
run;

data dsn1;
set dsn;
by age;
retain cumulative 0.;
if first.height then height+cumulative;
else  cumulative+height;
run;

Re: cumulative sum for height in proc sql

PeterClemmensen — Wed, 06 Nov 2019 10:08:58 GMT

If you simply want a cumulative sum of heights and do not want to consider by-groups, then no by-statement is needed in the data step. Simply do

proc sort data=sashelp.class out=dsn;
    by age;
run;

data want;
    set dsn;
    cumulative+height;
run;

Re: cumulative sum for height in proc sql

BrahmanandaRao — Wed, 06 Nov 2019 10:16:07 GMT

i want using proc sql sort by age variable and output cumulative sum of height

Re: cumulative sum for height in proc sql

PeterClemmensen — Wed, 06 Nov 2019 10:18:31 GMT

Why? So much easier with the data step

Re: cumulative sum for height in proc sql

BrahmanandaRao — Wed, 06 Nov 2019 10:19:54 GMT

Hi draycut

its just do for homework

Re: cumulative sum for height in proc sql

Kurt_Bremser — Wed, 06 Nov 2019 10:27:26 GMT

Dead simple:

create table
select age
also select sum(height) as cumulative
from sashelp.class
group by age

Build the SQL code by following the hints, and let us see what you come up with.

As already stated in another thread, I will not insult your intelligence by spoon-feeding you this very simple exercise.

PS a home exercise is for you to solve. If you can't, there's three possibilities:

you don't have what it takes for the course; drop out of the course and do something you're equipped for
you did not follow your teacher properly; be more attentive in the future
your teacher is not capable; take the course from someone else