Having standard deviation grouped by year and cusip

JKCho — Thu, 11 Jul 2019 19:33:51 GMT

proc sql;
create table Rstd as 
 select cusip and year,std(dailyr) as with_in_std 
  from rvol
   group by cusip, year;
quit;

I think this time I am even closer to the right answer than before. feels like I am learnings SAS more.

Yes. I know I do not have to put and year after cusip but simply do not know how to have grouped std...

I did both select cusip,std(dailyr) as with_in_std and select year,std(dailyr) as with_in_std

and it worked so good and saw groups std eight by cusip or year.

BUT... I want grouping using both year and cusip simultaneously.

I appreciate your help very much!

Re: Having standard deviation grouped by year and cusip

Reeza — Thu, 11 Jul 2019 19:48:19 GMT

proc sql;
create table Rstd as
select cusip, year,std(dailyr) as with_in_std
from rvol
group by cusip, year;
quit;