topic Re: creating variables by summing over conditional observations in SAS Programming

creating variables by summing over conditional observations

jdub — Tue, 12 Jul 2011 17:44:03 GMT

I have data like the following:

I am trying to create something like:

where hiresN is the sum of hires in the first data set over counties and age groups

How could I code this?

art297 — Tue, 12 Jul 2011 18:00:19 GMT

You could use:

proc summary data=have nway;

class year quarter naics;

var hires;

output out=want sum=hiresN;

run;

HTH,

Art

dhana — Wed, 13 Jul 2011 07:18:47 GMT

If you are familiar with PROC SQL then you can use that also.

PROC SQL;

SELECT YEAR,QUARTER,NAICS,SUM(HIRES) AS HIRESN

FROM NEWDS

GROUP BY YEAR, QUARTER, NAICS;

QUIT;

Thanks

Dhanasekaran R