cumulative sum for height in proc sql

[BrahmanandaRao]

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;

[PeterClemmensen]

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;

[BrahmanandaRao]

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

[PeterClemmensen]

Why? So much easier with the data step

[BrahmanandaRao]

Hi draycut 

its just do for homework 

[Kurt_Bremser]

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