
DSDR KB:
Q:
I have a neighborhood that I define by census tracts. How can I create characteristics for these neighborhoods in SAS
A:
Here’s an example of how you can sum in SAS.
The example has you multiplying size of census tract x pov for each census tract (in the neighborhood).
Sort by neighborhood. Sum these products across all census tracts in the neighborhood. End up with a single sum for a zip code
data a;
infile . . . ;
input . . . ;
wpov = total*pov;
proc sort; by neigh;
proc means noprint data=a;
by neigh;
var wpov;
output out=sum sum(wpov)=wpovx;
data b;
set sum;
proc print;
neigh wpovx;
Related Question Groups:
Notice: Undefined index: REMOTE_HOST in /opt/www/htdocs/psc/dis/data/kb/inc/pageCode_answer.inc on line 165