#SAS GEODIST EXAMPLE HOW TO#

So one of the key questions you can answer using geospatial analysis is the entity (campground, library, school, etc.) that is closest to another entity (your location, all the other campgrounds / libraries / schools, etc.). Before I imported it, I used the Excel “delete duplicates” tool (which removed the 1 record I mentioned above) and then imported it into the University Edition environment. Other than merging the data into a single Excel file, there wasn’t much I had to do.

#SAS GEODIST EXAMPLE HOW TO#

In this 9-minute tutorial, SAS instructor shows you how to get your data into SAS OnDemand for Academics and other key steps: Get started with SAS OnDemand for Academics The data can be downloaded here, and I recommend you copy / paste the list of short forms from the site into your code for easy reference.

The original dataset is multiple CSV files, which I merged, cleaned (I didn’t need all the variables, and there was 1 duplicate record) and imported into SAS University Edition. I’m using a crowdsourced dataset on campgrounds – I used to love camping as a kid, and was really excited to see this data. Having said that, there are some cool things you can do with some creativity, patience, and a bunch of SQL. Unfortunately, SAS University Edition does not come with the powerful geographic analytical tools that are standard in Base SAS, nor does University Edition have the ability to create the maps that can be done. Whether it’s looking at people who have come down with the flu, broken watermains, or traffic accidents, seeing it on a map can be much more effective that seeing it on a “regular” graph. Geospatial analysis is one of my favourite types of analysis - being able to take potentially complex, messy, and big data and see how it fits onto a map is just so cool.

Sas geodist example