There was a phone interview with the recruiter, and then they followed up two weeks later with a full day of interviews with 5 different groups or individuals including one at lunch. The first was with two technical people who quizzed me on some SQL. Then there were meetings with the Dept. Head, my new manager, and managers from areas I'd be working with.
In general the questions weren't difficult, but it was a long process. I realized half-way through that they wanted much more SAS experience than I had - though I never represented myself as a SAS expert in my resume or in the phone interview. So I was disappointed as I knew it was going to be a waste of a day.