Revisit: How do we use @ and @@ to enter data

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

Revisit Subsetting in SAS

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

ODS Excel – saving results directly into an Excel spreadsheet

I think it is very safe for me to say that most of us use Excel to enter our data. We may need to massage it to bring it into SAS for analysis, but that's what we do. So now let's sit back and think.... how many times have you wanted to move your analysis … Continue reading ODS Excel – saving results directly into an Excel spreadsheet

SASsy Fridays – Nov 24 – CANCELLED

Please note that this Friday’s SASsy Fridays meeting is cancelled. Sorry for the inconvenience and we will see you in the New Year! Stay tuned for dates and locations.

Proc MEANS (November 10)

So how many of us use Proc Means on a regular basis? I'm willing to guess a fair number of us. I'm also willing to put out there, because I know people do this - how many of you run the MEANS in SAS and then transcribe them to another dataset or another program? Yup! … Continue reading Proc MEANS (November 10)

Let’s talk SAS Data basics

For this Friday's SASsy session (October 27, 2017) let's talk about some of the basics of the DATA step. DATA statement Since most people use Excel to enter their data I like to draw comparisons between the two programs: Excel and SAS. As many of you know I LOVE examples, and yes, I will take … Continue reading Let’s talk SAS Data basics

Back Transformations for Lognormal Data

As we continue to move into the Proc GLIMMIX world, we are using more non-Gaussian data, such as binomial, Poisson, etc... When we take advantage of the strength of GLIMMIX and designate a non-Gaussian distribution, our LSMeans return to us in a transformed format. But, GLIMMIX has a great option called ILINK to be added … Continue reading Back Transformations for Lognormal Data

LSMEANS – Proc MIXED vs Proc GLIMMIX

Least Squares Means (LSMEANS) are just one of those outputs we all love to see in our SAS output. We've worked through the challenges of seeing the same standard error for all our means (remember it's based on the model and NOT the individual values) and we've learned how to use the PDMIX800 macro for … Continue reading LSMEANS – Proc MIXED vs Proc GLIMMIX

SASsy Fridays – Dates, Times, and Locations

Fall 2017 will see the revival of the SASsy Fridays sessions or the SASsy Fridays Community of Practice in OAC. The sessions will take place in the Crop Science Lab Rm 121A on the following dates and times: Friday, October 13 from 12:30-1:20 p.m. Friday, October 27 from 12:30-1:20 p.m. Friday, November 10 from 12:30-1:20 p.m. … Continue reading SASsy Fridays – Dates, Times, and Locations

I’m BACK!!! Starting October 2017

Hi all! I know it's been a LONG time! There have been a few attempts at restarting, but with my position at Cornell, it was tough to try and maintain this Blog along with my new responsibilities. Well... I'm back in Guelph and am extremely lucky to hold a WONDERFUL position where I will be … Continue reading I’m BACK!!! Starting October 2017