topic Re: How to obtain school district Name for a given address? in SAS Programming

How to obtain school district Name for a given address?

Akhila1 — Fri, 22 Jul 2022 15:16:42 GMT

I wish to know the school district for a given home address of a student.

Re: How to obtain school district Name for a given address?

ChrisHemedinger — Fri, 22 Jul 2022 15:13:45 GMT

You may be able to use SAS geocoding functions to convert an address to some other geo field (like a zip code or other region or lat/long), but you're going to need a database of school districts and their boundaries. Or sometimes the rules are more complex, and you need to use a web service (if available) to perform this lookup.

Re: How to obtain school district Name for a given address?

Reeza — Fri, 22 Jul 2022 15:14:21 GMT

You'll need to provide more details.

Do you have a data set of school districts of some kind? Maps of those spatial area's in SHP files?

What country are you in?

Re: How to obtain school district Name for a given address?

Akhila1 — Fri, 22 Jul 2022 15:19:42 GMT

I am in USA. I do not have a data set of school districts.

Re: How to obtain school district Name for a given address?

Reeza — Fri, 22 Jul 2022 15:22:19 GMT

Are you looking at all of USA or a particular state or region?
States/ municipalities often publish this data on their open data portal.

Example: https://catalog.data.gov/dataset/tiger-line-shapefile-2017-state-california-current-secondary-school-districts-shapefile-state-b

Re: How to obtain school district Name for a given address?

Reeza — Fri, 22 Jul 2022 15:26:44 GMT

Census Bureau is better it seems, single file:

https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries

Use PROC GEOCODE to map your addresses to lat/long
Use PROC MAPIMPORT to import the boundary file
Use PROC GINSIDE to determine which points from #1 belong to which regions in #2

If you have something like QGIS or ESRI ARCGIS this is more easily accomplished in those tools via point and click procedures except for Step #1.

Re: How to obtain school district Name for a given address?

ballardw — Fri, 22 Jul 2022 16:23:27 GMT

A possible issue may be that your school does not actually belong to a school district. School Districts typically are Public schools and do not consider a Private school in there geography as belonging to the district.

I have worked with public/ private mixed school data. If this is for a single state I might also search the department of education, or whatever a specific state might call it, website. I know in my state I can get such information along with enrollment and other bits in a single file.