Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

A questionnaire change: politics or not?

Finding “war brides” in the ACS

Census Bureau is considering adding a new Middle East/North Africa ethnic category

Big Data Initiative at NIH-OBSSR

UM Now Has Access to IndiaStat

Data Services Knowledge Base

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;

Annotated Resources:

Related Question Groups: