Ah yes - that lovely word Excel 😉 Many of my students enter their data into Excel - fair. I do it too, so easy to see where and how to enter my data in a spreadsheet format. Then we ensure that the data is clean before we bring it into SAS to run our … Continue reading SAS to Excel
Oh wow! It's been sooo long since I've been on here. If there's anyone following this blog - so sorry! Life got in the way, but I'm back! Over this summer I'll be posting little SAS tidbits - a request my students made this past semester and it hit me that I was doing that … Continue reading Hello – hello…..
Calculating the Area Under the Curve is used in many different fields of research and departments here at the University of Guelph. The example we will work through here, is one from Food Science. A PDF version of the Powerpoint presentation used for this session can be viewed here. The presentation explains the process of … Continue reading Area Under the Curve
We talked about Path Analysis a couple of years ago, and today we'll work through an example in SAS using PROC CALIS. To date, we've had a couple of researchers using this PROC to review their data, which is very exciting! Path analysis is a really cool analysis that I suspect may be underused. Why? … Continue reading Path Analysis
After talking with folks during this past month, it has come to my attention that maintaining Friday noon sessions will be tough on everyone doing their research. So SASsy Fridays will return in the Fall!
In case folks were wondering there will be NO SASsy Fridays session this coming Friday, April 13. SASsy Fridays will resume in May. Stay tuned for dates and topics
PDF copy of the SAS syntax file used for this session. We say SAS - we think statistics! We think statistics - we say SAS! We think maps and GIS - SAS is probably the last program you think to use. There are so many other options out there, why would you use SAS? Well... … Continue reading More than just Statistics – Can we Map in SAS?
This may be a short post but I think one that folks will find may come in handy. I was recently asked how to calculate a difference of a variable listed in 2 rows. As a made-up example. I have 2 weight observations on some unit and I want to calculate the difference between the … Continue reading Calculating differences using DIF( ) and LAG( ) functions
I've been reminded of how we can take advantage of the @ and @@ in SAS when entering data. There have been a few students using this code, which I think is wonderful, and something I'd like to revisit and maybe remind folks on what these symbols do and how we can use them. We … Continue reading Revisit: How do we use @ and @@ to enter data
With new students learning SAS on campus, sometimes it is handy to revisit some of the posts we created a few years ago. One such post is Subsetting data with the IF and WHERE statement. In this week's SAS workshop we're looking at Merging data and creating new variables, so revisiting Subsetting is a nice … Continue reading Revisit Subsetting in SAS