When I downloaded the data, it looked like this: Voting results for the 2010 election are available here. Some cities have the same mayor for a decade or longer. Oakville, like other cities in Ontario, is very devoted to the mayor – continuously re-electing incumbents. I figured it was a good place to find some data to use, and I was right. She was very impressed that Oakville’s recently been awarded the ISO’s 37120 Platinum Certification, which recognizes the town’s efforts at measuring performance and maintaining and expanding the Open Data program. I have friends that live in the town of Oakville (about 45 minutes outside of Toronto) and one is a huge advocate for open data. So, although I know how to get data into SAS, I’ve always copied and pasted what I needed this adventure into exporting was exciting to me. I realised that I could just provide a simple list, but that wasn’t going to work – the admin for Dr Jones doesn’t want to see Dr Brown’s procedures and vice versa. I was asked to pull a list of our surgeons and the procedures they’re authorised to do considering we have over 115 doctors, and over 900 procedures available, that was going to take a very long time. I work for a hospital in Toronto, Canada and one of my roles is the “Computer Geek” for the operating room – I’m responsible for hardware, software support, data analysis, database admin, etc. Every so often, I learn something new in SAS that’s so simple and useful, it once again proves how powerful a tool SAS truly is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |