SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
Lantern
Calcite | Level 5

Hi,

I am relatively new to SAS.  I used proc transreg to Box Cox transform my data, but I am at a loss for how to proceed from here.  Do I need to output the transformed data and use that new data file  in the proc mixed model statement, or can I incorporate the transformation statement into the proc mixed code?  I've very sorry for the simple question, but I have searched various SAS/statistics help forums, Googled it, and I cannot find an answer.  Details are appreciated. 

Thanks so much!

Lan

3 REPLIES 3
SteveDenham
Jade | Level 19

Using the transformed dependent data is fine.  Remember that all lsmeans and their standard errors are on the transformed scale.  If you happened to find a "convenient" transformation through Box-Cox, you may wish to consider using GLIMMIX, provided an appropriate distribution can be specified.

Steve Denham

lvm
Rhodochrosite | Level 12 lvm
Rhodochrosite | Level 12

One would typically just transform the response variable in a data step, and then use this in MIXED. Now here is something if you are more ambitious. If you are using MIXED, you probably have random effects in your model, or repeated measures. But TRANSREG does not use the random effects in determining the power coefficient for Box-Cox. Hans-Peter Piepho wrote a macro to determine lambda  power coefficient for a mixed model. It uses profile likelihoods by calling MIXED multiple times. (Piepho. 2009. Agronomy Journal 101(4): 865-869). But someone new to SAS could struggle with this. I mostly point this out for the more experienced SAS users.

Lantern
Calcite | Level 5

Thanks!  You're right, I do have random effects and repeated measures.  The macro you mentioned sounds a bit over my head, but I will have a look at the paper and see if I can work it out.  Thanks so much!

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2333 views
  • 0 likes
  • 3 in conversation