I wish to know the school district for a given home address of a student.
Census Bureau is better it seems, single file:
https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries
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.
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.
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?
Are you looking at all of USA or a particular state or region?
States/ municipalities often publish this data on their open data portal.
Census Bureau is better it seems, single file:
https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: